APPS.PQP_PENSION_FUNCTIONS dependencies on PER_COLLECTIVE_AGREEMENTS

Line 2083: FROM per_collective_agreements cola

2079: -- =======================================================================
2080: CURSOR c_cag_name (c_asg_id IN NUMBER
2081: ,c_eff_date IN DATE) IS
2082: SELECT cola.name
2083: FROM per_collective_agreements cola
2084: ,per_all_assignments_f asg
2085: WHERE asg.assignment_id = c_asg_id
2086: AND asg.collective_agreement_id = cola.collective_agreement_id
2087: AND cola.status = 'A'

Line 2248: l_cag_name per_collective_agreements.name%TYPE;

2244: l_inflation_per NUMBER;
2245: l_per_age NUMBER;
2246: l_max_inflated_sal NUMBER;
2247: l_min_holiday_allow NUMBER;
2248: l_cag_name per_collective_agreements.name%TYPE;
2249: l_min_holiday_char VARCHAR2(80);
2250: l_max_periods NUMBER;
2251: l_ptp_choice VARCHAR2(1);
2252: l_max_ptp NUMBER := 0;