CREATE TABLE program_sa
  (PGM_ID NUMBER, PGM_NAME VARCHAR2(10)
  );
ALTER TABLE program_sa ADD CONSTRAINT pk1 PRIMARY KEY(pgm_id);

CREATE TABLE program_assn
  (
    PGM_ID   NUMBER,
    BEGIN_DT DATE,
    END_DATE DATE,
    STATUS   VARCHAR2(3),
    CONSTRAINT fk1 FOREIGN KEY(pgm_id) REFERENCES program_sa(pgm_id)
  );

-- inserts for master
INSERT INTO program_sa VALUES
  (1,'Health'
  );
INSERT INTO program_sa VALUES
  (2,'Education'
  );
INSERT INTO program_sa VALUES
  (3,'Sports'
  );

-- for detail table
INSERT INTO program_assn VALUES
  (1,'01-Jan-2014', '10-Jan-14', 'AC'
  );
INSERT INTO program_assn VALUES
  (1,'11-Jan-2014', '20-Jan-14', 'PE'
  );
INSERT INTO program_assn VALUES
  (1,'21-Jan-2014', '31-Jan-14', 'DS'
  );

SELECT *
FROM program_sa p ,
  program_assn pa
WHERE p.PGM_ID      = pa.PGM_ID(+)
 ;

SELECT *
FROM program_sa p ,
  program_assn pa
WHERE p.PGM_ID      = pa.PGM_ID(+)
AND pa.begin_dt(+) IN
  (SELECT MAX(begin_dt) FROM PROGRAM_ASSN pa1 GROUP BY pa1.pgm_id
  )
  ;

Program_ID  Program_Name   Begin_Dt    End_Dt      Status
-----------------------------------------------------------
1           Health         21-Jan-14   31-Jan-14   DS
2           Education      NULL        NULL        NULL
3           Sports         NULL        NULL        NULL

SQL> INSERT INTO program_assn VALUES
  2    (1,'01-Jan-2014', '10-Jan-14', 'AC'
  3    );
  (1,'01-Jan-2014', '10-Jan-14', 'AC'
     *
ERROR at line 2:
ORA-01858: a non-numeric character was found where a numeric was expected

INSERT
INTO program_assn VALUES
  (
    1,
    TRUNC(SYSDATE,'RRRR'),
    TRUNC(SYSDATE,'RRRR') + 9 ,
    'AC'
  );
INSERT
INTO program_assn VALUES
  (
    2,
    TRUNC(SYSDATE,'RRRR') +10,
    TRUNC(SYSDATE,'RRRR') +19 ,
    'PE'
  );
INSERT
INTO program_assn VALUES
  (
    3,
    TRUNC(SYSDATE,'RRRR')+20,
    LAST_DAY(TRUNC(SYSDATE,'RRRR')) ,
    'DS'
  );