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: 28-JUN-11 rosuri 115.13 12664972 Modified the cursor mmrf_sqwl_employer.
69: 25-JAN-13 sjawid 115.14 14456648 Added cursor smwl_employee

Line 196: from per_all_people_f PE,

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

Line 237: from per_all_people_f PE,

233: 'ASSIGNMENT_ID=C' , AA.assignment_id,
234: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
235: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
236: (PA.effective_date, AA.assignment_id))
237: from per_all_people_f PE,
238: per_all_assignments_f SS,
239: pay_assignment_actions AA,
240: pay_payroll_actions PA
241: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 282: per_all_people_f PE,

278: ('TRANSFER_REPORT_CATEGORY')
279: from pay_payroll_actions PA,
280: pay_assignment_actions AA,
281: per_all_assignments_f SS,
282: per_all_people_f PE,
283: ff_archive_items fai,
284: ff_user_entities fue
285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
286: ('TRANSFER_PAYROLL_ACTION_ID')

Line 521: from per_all_people_f PE,

517: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,
518: 'ASSIGNMENT_ID=C' , AA.assignment_id,
519: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
521: from per_all_people_f PE,
522: per_all_assignments_f SS,
523: pay_assignment_actions AA,
524: pay_payroll_actions PA
525: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value