APPS.PAY_NL_SI_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 68: per_assignment_extra_info paei

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

Line 84: per_assignment_extra_info paei

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

Line 189: per_assignment_extra_info paei

185: CURSOR Cur_SI_AMI IS
186: SELECT
187: DECODE(paei.AEI_INFORMATION3,'AMI',1,0) si_class_order
188: FROM
189: per_assignment_extra_info paei
190: WHERE
191: assignment_id = p_assignment_id
192: and paei.aei_information_category='NL_SII'
193: and p_date_earned between