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 98: from pay_state_rules SR,

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

Line 133: pay_state_rules SR,

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

Line 177: from pay_state_rules SR,

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

Line 418: from pay_state_rules SR,

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

Line 518: from pay_state_rules SR,

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