DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on BEN_PGM_F

Line 1675: FROM ben_pgm_f pgm

1671: AND effective_start_date = p_old_start_date;
1672: --
1673: CURSOR csr_is_pgm_valid(p_pgm_id number) IS
1674: SELECT NULL
1675: FROM ben_pgm_f pgm
1676: WHERE pgm.pgm_id = p_pgm_id
1677: AND p_new_start_date between pgm.effective_start_date
1678: and pgm.effective_end_date;
1679: --