APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 65: Also replaced per_all_people_f by per_people_f

61: 11-Jan-2005 sackumar 115.11 4869678 Modified the cursor sqwl_employer_m to remove Merge Join Cartesian
62: Modified the cursor sqwl_employee_m to remove Merge Join Cartesian
63: Modified the cursor mmrf_nysqwl_employer to remove Full Table Scan on
64: hr_all_organization_units and hr_organization_information.
65: Also replaced per_all_people_f by per_people_f
66: and per_all_assignment_f by per_assignment_f to reduce the shared memory.
67: 16-Aug-2006 sackumar 115.12 5379670 Created a global cursor MESQWL_RECONCILIATION.
68:
69: */

Line 194: from per_all_people_f PE,

190: 'ASSIGNMENT_ID=C' , AA.assignment_id,
191: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
192: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
193: (PA.effective_date, AA.assignment_id))
194: from per_all_people_f PE,
195: per_all_assignments_f SS,
196: pay_assignment_actions AA,
197: pay_payroll_actions PA
198: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 245: per_all_people_f PE,

241: ('TRANSFER_REPORT_CATEGORY')
242: from pay_payroll_actions PA,
243: pay_assignment_actions AA,
244: per_all_assignments_f SS,
245: per_all_people_f PE,
246: ff_archive_items fai,
247: ff_user_entities fue
248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
249: ('TRANSFER_PAYROLL_ACTION_ID')

Line 482: from per_all_people_f PE,

478: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
479: 'ASSIGNMENT_ID=C' , AA.assignment_id,
480: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
481: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
482: from per_all_people_f PE,
483: per_all_assignments_f SS,
484: pay_assignment_actions AA,
485: pay_payroll_actions PA
486: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value