APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 923: FROM per_assignment_extra_info

919: CURSOR csr_get_override_salary(c_assignment_id IN NUMBER
920: ,c_effective_date IN DATE) IS
921: SELECT nvl (aei_information6
922: ,'0')
923: FROM per_assignment_extra_info
924: WHERE assignment_id = c_assignment_id
925: AND information_type = 'NL_ABP_PAR_INFO'
926: AND aei_information_category = 'NL_ABP_PAR_INFO'
927: AND c_effective_date BETWEEN trunc (fnd_date.canonical_to_date (aei_information1))

Line 2797: FROM per_assignment_extra_info

2793: ,c_effective_date IN DATE) IS
2794: SELECT aei_information4 kop
2795: ,least (fnd_number.canonical_to_number (aei_information5)
2796: ,1) * 100 vop
2797: FROM per_assignment_extra_info
2798: WHERE information_type = 'NL_ABP_PAR_INFO'
2799: AND aei_information_category = 'NL_ABP_PAR_INFO'
2800: AND assignment_id = c_assignment_id
2801: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)

Line 2812: FROM per_assignment_extra_info

2808: SELECT aei_information4 kop
2809: , least (fnd_number.canonical_to_number (aei_information5), 1) * 100 vop
2810: , fnd_date.canonical_to_date (aei_information1) kop_start_date
2811: , nvl (fnd_date.canonical_to_date (aei_information2), c_eff_end_date) kop_end_date
2812: FROM per_assignment_extra_info
2813: WHERE information_type = 'NL_ABP_PAR_INFO'
2814: AND aei_information_category = 'NL_ABP_PAR_INFO'
2815: AND assignment_id = c_assignment_id
2816: AND fnd_date.canonical_to_date (aei_information1) <= c_eff_end_date

Line 2828: , per_assignment_extra_info paei

2824: FROM (
2825: SELECT pai.action_information1 start_date
2826: , least (fnd_number.canonical_to_number (paei.aei_information5), 1) * 100 vop
2827: FROM pay_action_information pai
2828: , per_assignment_extra_info paei
2829: WHERE paei.information_type = 'NL_ABP_PAR_INFO'
2830: AND paei.aei_information_category = 'NL_ABP_PAR_INFO'
2831: AND paei.assignment_id = pai.assignment_id
2832: AND pai.action_context_id = c_ass_act_id

Line 3002: FROM per_assignment_extra_info

2998: SELECT decode (aei_information5
2999: ,'Y'
3000: ,'G'
3001: ,NULL) obj_cd
3002: FROM per_assignment_extra_info
3003: WHERE assignment_id = c_assignment_id
3004: AND information_type = 'NL_USZO_INFO'
3005: AND trunc (c_effective_date) BETWEEN fnd_date.canonical_to_date (aei_information1)
3006: AND nvl (fnd_date.canonical_to_date (aei_information2)

Line 3109: FROM per_assignment_extra_info pei

3105: --=========================================================================
3106: -- Withdrawal Info
3107: CURSOR csr_get_withdrawal_flag(c_asg_id IN NUMBER) IS
3108: SELECT pei.aei_information24 withdr_flag
3109: FROM per_assignment_extra_info pei
3110: WHERE pei.information_type = 'NL_ABP_PI'
3111: AND pei.aei_information_category = 'NL_ABP_PI'
3112: AND pei.assignment_id = c_asg_id;
3113: --=========================================================================