APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_COLLECTIVE_AGREEMENTS

Line 1265: FROM per_collective_agreements cola

1261: --
1262: CURSOR c_cag_name (c_asg_id IN NUMBER
1263: ,c_eff_date IN DATE) IS
1264: SELECT cola.name
1265: FROM per_collective_agreements cola
1266: ,per_all_assignments_f asg
1267: WHERE asg.assignment_id = c_asg_id
1268: AND asg.collective_agreement_id = cola.collective_agreement_id
1269: AND cola.status = 'A'

Line 1406: l_cag_name per_collective_agreements.name%TYPE;

1402: l_eoy_bonus NUMBER := 0;
1403: l_eoy_bonus_per NUMBER := 0;
1404: l_min_eoy_bonus NUMBER := 0;
1405: l_min_eoy_bonus_char VARCHAR2(80);
1406: l_cag_name per_collective_agreements.name%TYPE;
1407: l_max_periods NUMBER;
1408: l_max_ptp NUMBER := 0;
1409: l_prev_max_ptp NUMBER := 0;
1410: l_ret_val NUMBER := 0;