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: 28-JUN-11 rosuri 115.13 12664972 Modified the cursor mmrf_sqwl_employer.

Line 136: hr_organization_information hoi

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

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

434: --
435:
436: /* added for MMREF SQWLs */
437:
438: /* for bug 2752145, commented the join with hr_organization_information,
439: this to remove the dependency on W2 reporting rules for SQWL */
440: cursor mmrf_sqwl_transmitter is
441: select 'TAX_UNIT_ID=C',
442: pay_magtape_generic.get_parameter_value ('TRANSFER_TRANS_LEGAL_CO_ID'),

Line 458: -- hr_organization_information hoi,

454: ('TRANSFER_REPORT_CATEGORY')
455: from pay_state_rules SR,
456: ff_archive_items ffai,
457: ff_database_items fdi,
458: -- hr_organization_information hoi,
459: pay_payroll_actions ppa
460: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
461: ('TRANSFER_PAYROLL_ACTION_ID')
462: -- and hoi.organization_id = pay_magtape_generic.get_parameter_value

Line 504: hr_organization_information hoi,

500: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
501: 'TAX_UNIT_NAME=P' , hou.name,
502: 'FEIN=P' , hoi.org_information1
503: from hr_all_organization_units hou,
504: hr_organization_information hoi,
505: pay_assignment_actions AA,
506: pay_payroll_actions PA
507: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
508: ('TRANSFER_PAYROLL_ACTION_ID')

Line 558: hr_organization_information hoi

554: select 'TRANSFER_DATE_WAGES_PAID_ME=P', hoi.org_information2,
555: 'TRANSFER_AMOUNT_WITHHELD_ME=P', hoi.org_information3,
556: 'TRANSFER_PAYMENT_DEPOSITED_ME=P', hoi.org_information4
557: from pay_state_rules SR,
558: hr_organization_information hoi
559: where SR.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')
560: and hoi.org_information_context = 'SQWL Employer Rules 3'
561: and hoi.organization_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
562: and hoi.org_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_STATE')