APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 64: hr_all_organization_units and hr_organization_information.

60: 06-AUG-2003 fusman 115.8 3094891 Moved all the sqwl cursors to pay_us_sqwl_archive package header.
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:

Line 444: from hr_all_organization_units hou,

440: 'TAX_UNIT_ID=C' , AA.tax_unit_id,
441: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
442: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
443: 'TAX_UNIT_NAME=P' , hou.name
444: from hr_all_organization_units hou,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
448: ('TRANSFER_PAYROLL_ACTION_ID')

Line 464: from hr_all_organization_units hou,

460: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
461: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
462: 'TAX_UNIT_NAME=P' , hou.name,
463: 'FEIN=P' , hoi.org_information1
464: from hr_all_organization_units hou,
465: hr_organization_information hoi,
466: pay_assignment_actions AA,
467: pay_payroll_actions PA
468: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value