APPS.PER_PCE_BUS dependencies on PER_CAGR_ENTITLEMENT_LINES_F

Line 1040: FROM per_cagr_entitlement_lines_f pcl

1036: -- Declare Cursors
1037: --
1038: CURSOR csr_check_line_end_dates IS
1039: SELECT 'X'
1040: FROM per_cagr_entitlement_lines_f pcl
1041: WHERE pcl.cagr_entitlement_id = p_cagr_entitlement_id
1042: AND DECODE(pcl.effective_end_date
1043: ,hr_general.end_of_time,hr_general.start_of_time
1044: ,pcl.effective_end_date) > NVL(p_end_date,hr_general.end_of_time);

Line 1076: -- any per_cagr_entitlement_lines_f

1072: --
1073: END IF;
1074: --
1075: -- Check that the end_date is not before any end dates for
1076: -- any per_cagr_entitlement_lines_f
1077: --
1078: OPEN csr_check_line_end_dates;
1079: FETCH csr_check_line_end_dates INTO l_dummy;
1080: --