APPS.PQP_NL_PGGM_FUNCTIONS dependencies on PER_COLLECTIVE_AGREEMENTS

Line 1111: FROM per_collective_agreements cola

1107: --
1108: CURSOR c_cag_name (c_asg_id IN NUMBER
1109: ,c_eff_date IN DATE) IS
1110: SELECT cola.name
1111: FROM per_collective_agreements cola
1112: ,per_all_assignments_f asg
1113: WHERE asg.assignment_id = c_asg_id
1114: AND asg.collective_agreement_id = cola.collective_agreement_id
1115: AND cola.status = 'A'

Line 1252: l_cag_name per_collective_agreements.name%TYPE;

1248: l_eoy_bonus NUMBER := 0;
1249: l_eoy_bonus_per NUMBER := 0;
1250: l_min_eoy_bonus NUMBER := 0;
1251: l_min_eoy_bonus_char VARCHAR2(80);
1252: l_cag_name per_collective_agreements.name%TYPE;
1253: l_max_periods NUMBER;
1254: l_max_ptp NUMBER := 0;
1255: l_prev_max_ptp NUMBER := 0;
1256: l_ret_val NUMBER := 0;