APPS.PAY_CN_AUDIT_XMLGEN dependencies on PER_PEOPLE_F

Line 130: FROM per_people_f ppf,

126: hr_utility.trace ('Entering '||l_proc);
127: END IF ;
128:
129: p_sqlstr := 'SELECT DISTINCT person_id
130: FROM per_people_f ppf,
131: pay_payroll_actions ppa
132: WHERE ppa.payroll_action_id = :payroll_action_id
133: AND ppa.business_group_id +0 = ppf.business_group_id
134: ORDER BY ppf.person_id';

Line 175: FROM per_people_f ppf,

171: -- Ensure those are within the accounting period range
172: --
173: CURSOR csr_assignments IS
174: SELECT paf.assignment_id
175: FROM per_people_f ppf,
176: per_assignments_f paf,
177: per_periods_of_service pos
178: WHERE ppf.business_group_id = paf.business_group_id
179: AND pos.period_of_service_id = paf.period_of_service_id

Line 1549: per_people_f ppf,

1545:
1546: sqlstr := ' select paa.rowid
1547: from pay_assignment_actions paa,
1548: pay_payroll_actions ppa ,
1549: per_people_f ppf,
1550: pay_payrolls_f p
1551: where ppa.payroll_action_id = :pactid
1552: and paa.payroll_action_id = ppa.payroll_action_id
1553: AND '''||g_end_date||''' between p.effective_start_date and p.effective_end_date