eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

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 134: hr_organization_information hoi

130: ('TRANSFER_REPORT_CATEGORY')
131: from pay_payroll_actions PA,
132: pay_assignment_actions AA,
133: pay_state_rules SR,
134: hr_organization_information hoi
135: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
136: ('TRANSFER_PAYROLL_ACTION_ID')
137: and PA.payroll_action_id = AA.payroll_action_id
138: and SR.state_code = pay_magtape_generic.get_parameter_value

Line 401: /* for bug 2752145, commented the join with hr_organization_information,

397: --
398:
399: /* added for MMREF SQWLs */
400:
401: /* for bug 2752145, commented the join with hr_organization_information,
402: this to remove the dependency on W2 reporting rules for SQWL */
403: cursor mmrf_sqwl_transmitter is
404: select 'TAX_UNIT_ID=C',
405: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),

Line 421: -- hr_organization_information hoi,

417: ('TRANSFER_REPORT_CATEGORY')
418: from pay_state_rules SR,
419: ff_archive_items ffai,
420: ff_database_items fdi,
421: -- hr_organization_information hoi,
422: pay_payroll_actions ppa
423: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
424: ('TRANSFER_PAYROLL_ACTION_ID')
425: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value

Line 465: hr_organization_information hoi,

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
469: ('TRANSFER_PAYROLL_ACTION_ID')

Line 519: hr_organization_information hoi

515: select 'TRANSFER_DATE_WAGES_PAID_ME=P', hoi.org_information2,
516: 'TRANSFER_AMOUNT_WITHHELD_ME=P', hoi.org_information3,
517: 'TRANSFER_PAYMENT_DEPOSITED_ME=P', hoi.org_information4
518: from pay_state_rules SR,
519: hr_organization_information hoi
520: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
521: and hoi.org_information_context = 'SQWL Employer Rules 3'
522: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
523: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')