APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 580: FROM per_assignment_extra_info

576:
577: CURSOR
578: c_get_avg_si_assignment(c_assignment_id IN NUMBER) IS
579: SELECT aei_information1,aei_information2
580: FROM per_assignment_extra_info
581: WHERE information_type= 'NL_PAI'
582: AND assignment_id = c_assignment_id;
583:
584: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS

Line 2173: FROM per_assignment_extra_info

2169: -- Cursor to get the choice for average PTP calculation from ASG EIT
2170: -- =======================================================================
2171: CURSOR c_asg_ptp_choice(c_eff_date IN DATE) IS
2172: SELECT aei_information10
2173: FROM per_assignment_extra_info
2174: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2175: AND information_type = 'NL_ABP_PAR_INFO'
2176: AND assignment_id = p_assignment_id
2177: AND aei_information10 IS NOT NULL

Line 2197: FROM per_assignment_extra_info

2193: -- Cursor to get the choice for OHT Correction from ASG EIT
2194: -- =======================================================================
2195: CURSOR c_asg_oht_choice(c_eff_date IN DATE) IS
2196: SELECT aei_information11
2197: FROM per_assignment_extra_info
2198: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2199: AND information_type = 'NL_ABP_PAR_INFO'
2200: AND assignment_id = p_assignment_id
2201: AND aei_information11 IS NOT NULL

Line 4837: FROM per_assignment_extra_info

4833: --if a row exists for this savings type and the same period number
4834:
4835: CURSOR c_get_addnl_amt IS
4836: SELECT fnd_number.canonical_to_number(aei_information3)
4837: FROM per_assignment_extra_info
4838: WHERE assignment_id = p_assignment_id
4839: AND aei_information1 = to_char(p_pension_type_id)
4840: AND aei_information2 = to_char(p_payroll_period_number)
4841: AND p_date_earned BETWEEN fnd_date.canonical_to_date(nvl(aei_information4,fnd_date.date_to_canonical(to_date('01-01-1951','dd-mm-yyyy'))))