APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 538: FROM per_assignment_extra_info

534:
535: CURSOR
536: c_get_avg_si_assignment(c_assignment_id IN NUMBER) IS
537: SELECT aei_information1,aei_information2
538: FROM per_assignment_extra_info
539: WHERE information_type= 'NL_PAI'
540: AND assignment_id = c_assignment_id;
541:
542: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS

Line 2108: FROM per_assignment_extra_info

2104: -- Cursor to get the choice for average PTP calculation from ASG EIT
2105: -- =======================================================================
2106: CURSOR c_asg_ptp_choice(c_eff_date IN DATE) IS
2107: SELECT aei_information10
2108: FROM per_assignment_extra_info
2109: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2110: AND information_type = 'NL_ABP_PAR_INFO'
2111: AND assignment_id = p_assignment_id
2112: AND aei_information10 IS NOT NULL

Line 2132: FROM per_assignment_extra_info

2128: -- Cursor to get the choice for OHT Correction from ASG EIT
2129: -- =======================================================================
2130: CURSOR c_asg_oht_choice(c_eff_date IN DATE) IS
2131: SELECT aei_information11
2132: FROM per_assignment_extra_info
2133: WHERE aei_information_category = 'NL_ABP_PAR_INFO'
2134: AND information_type = 'NL_ABP_PAR_INFO'
2135: AND assignment_id = p_assignment_id
2136: AND aei_information11 IS NOT NULL

Line 4740: FROM per_assignment_extra_info

4736: --if a row exists for this savings type and the same period number
4737:
4738: CURSOR c_get_addnl_amt IS
4739: SELECT fnd_number.canonical_to_number(aei_information3)
4740: FROM per_assignment_extra_info
4741: WHERE assignment_id = p_assignment_id
4742: AND aei_information1 = to_char(p_pension_type_id)
4743: AND aei_information2 = to_char(p_payroll_period_number)
4744: 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'))))