APPS.PAY_NZ_EMS dependencies on PER_PEOPLE_F

Line 167: , per_people_f p /*Bug No 2920728*/

163: b.paye_deductions,
164: b.child_support_deductions,b.student_loan_deductions)),-1,0 /* Bug No : 2755544 */
165: ,decode(sign(b.gross_earnings - (b.paye_deductions + b.child_support_deductions + b.student_loan_deductions)),-1,0,1)) flag
166: from hr_organization_units ou /*Bug No 2920728*/
167: , per_people_f p /*Bug No 2920728*/
168: , per_assignments_f a
169: , hr_soft_coding_keyflex scl
170: , pay_nz_asg_cal_mth_bal_v b
171: , pay_element_types_f et

Line 193: from per_people_f p2 /*Bug No 2920728*/

189: and p.effective_start_date <= last_day(s.effective_date)
190: and p.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
191: -- the following sub query makes sure that we get the person record in effect at the end of the month
192: and p.effective_start_date = (select max(p2.effective_start_date)
193: from per_people_f p2 /*Bug No 2920728*/
194: where p2.person_id = p.person_id
195: and p2.effective_start_date <= last_day(s.effective_date)
196: )
197: and scl.soft_coding_keyflex_id = a.soft_coding_keyflex_id