APPS.PQP_PENSION_FUNCTIONS dependencies on PER_COLLECTIVE_AGREEMENTS

Line 2148: FROM per_collective_agreements cola

2144: -- =======================================================================
2145: CURSOR c_cag_name (c_asg_id IN NUMBER
2146: ,c_eff_date IN DATE) IS
2147: SELECT cola.name
2148: FROM per_collective_agreements cola
2149: ,per_all_assignments_f asg
2150: WHERE asg.assignment_id = c_asg_id
2151: AND asg.collective_agreement_id = cola.collective_agreement_id
2152: AND cola.status = 'A'

Line 2315: l_cag_name per_collective_agreements.name%TYPE;

2311: l_inflation_per NUMBER;
2312: l_per_age NUMBER;
2313: l_max_inflated_sal NUMBER;
2314: l_min_holiday_allow NUMBER;
2315: l_cag_name per_collective_agreements.name%TYPE;
2316: l_min_holiday_char VARCHAR2(80);
2317: l_max_periods NUMBER;
2318: l_ptp_choice VARCHAR2(1);
2319: l_max_ptp NUMBER := 0;