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 PAY_STATE_RULES

Line 100: from pay_state_rules SR,

96: 'JURISDICTION_CODE=C', SR.jurisdiction_code,
97: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(PA.effective_date),
98: 'BUSINESS_GROUP_ID=C', PA.business_group_id,
99: 'TRANSFER_BUSINESS_GROUP_ID=P', PA.business_group_id
100: from pay_state_rules SR,
101: pay_assignment_actions AA,
102: pay_payroll_actions PA
103: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
104: ('TRANSFER_PAYROLL_ACTION_ID')

Line 135: pay_state_rules SR,

131: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
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

Line 179: from pay_state_rules SR,

175: pay_magtape_generic.get_parameter_value
176: ('TRANSFER_PAYROLL_ACTION_ID'),
177: 'TRANSFER_SUI_WAGE_BASE=P',
178: nvl(FFAI.value,' ')
179: from pay_state_rules SR,
180: ff_archive_items ffai,
181: ff_database_items fdi
182: where SR.state_code = pay_magtape_generic.get_parameter_value
183: ('TRANSFER_STATE')

Line 455: from pay_state_rules SR,

451: 'TRANSFER_BUSINESS_GROUP_ID=P',PPA.business_group_id,
452: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),
453: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value
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

Line 557: from pay_state_rules SR,

553: cursor sqwl_reconciliation is
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')