eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PCL_BUS dependencies on BEN_OIPL_F

Line 1405: -- Validate that oipl_id is refrenced from ben_oipl_f.

1401: -- ---------------------------------------------------------------------------
1402: --
1403: -- Desciption :
1404: --
1405: -- Validate that oipl_id is refrenced from ben_oipl_f.
1406: --
1407: -- Pre-conditions :
1408: --
1409: --

Line 1442: FROM ben_oipl_f bof

1438: -- Delcare Cursors
1439: --
1440: CURSOR csr_chk_oipl_fk_start IS
1441: SELECT 'Y'
1442: FROM ben_oipl_f bof
1443: WHERE bof.oipl_id = p_oipl_id
1444: AND p_validation_start_date
1445: BETWEEN bof.effective_start_date AND bof.effective_end_date ;
1446: --

Line 1449: FROM ben_oipl_f bof

1445: BETWEEN bof.effective_start_date AND bof.effective_end_date ;
1446: --
1447: CURSOR csr_chk_oipl_fk_end IS
1448: SELECT 'Y'
1449: FROM ben_oipl_f bof
1450: WHERE bof.oipl_id = p_oipl_id
1451: AND p_validation_end_date
1452: BETWEEN bof.effective_start_date AND bof.effective_end_date;
1453: --