APPS.PAY_NL_SI_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 66: per_assignment_extra_info paei

62: SELECT paei.AEI_INFORMATION4 SI_Status,
63: paei.AEI_INFORMATION3 SI_Class,
64: DECODE(paei.AEI_INFORMATION3,'AMI',0,1) si_class_order
65: FROM
66: per_assignment_extra_info paei
67: WHERE
68: assignment_id = p_assignment_id
69: and paei.aei_information_category='NL_SII'
70: and (paei.AEI_INFORMATION3 = p_si_class or

Line 82: per_assignment_extra_info paei

78: CURSOR Cur_ZVW_Excluded(p_dt_earned NUMBER)
79: IS
80: SELECT nvl(paei.AEI_INFORMATION2,'N') ZVW_Excluded
81: FROM
82: per_assignment_extra_info paei
83: WHERE assignment_id = p_assignment_id
84: and paei.aei_information_category='NL_EXCL_ZVW'
85: and (to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION1),'RRRR') <= p_dt_earned
86: AND nvl(to_char(fnd_date.canonical_to_date(paei.AEI_INFORMATION3),'RRRR'),'4712') >= p_dt_earned);

Line 173: per_assignment_extra_info paei

169: CURSOR Cur_SI_AMI IS
170: SELECT
171: DECODE(paei.AEI_INFORMATION3,'AMI',1,0) si_class_order
172: FROM
173: per_assignment_extra_info paei
174: WHERE
175: assignment_id = p_assignment_id
176: and paei.aei_information_category='NL_SII'
177: and p_date_earned between