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_PAYROLL_ACTIONS

Line 102: pay_payroll_actions PA

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')
105: and PA.payroll_action_id = AA.payroll_action_id
106: and SR.state_code = pay_magtape_generic.get_parameter_value

Line 133: from pay_payroll_actions PA,

129: 'TRANSFER_COMPANY_SUI_ID=P', hoi.org_information2,
130: 'TRANSFER_WAGE_PLAN_CODE=P', hoi.org_information3,
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

Line 199: pay_payroll_actions PA

195: (PA.effective_date, AA.assignment_id))
196: from per_all_people_f PE,
197: per_all_assignments_f SS,
198: pay_assignment_actions AA,
199: pay_payroll_actions PA
200: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
201: ('TRANSFER_PAYROLL_ACTION_ID')
202: and AA.payroll_action_id = PA.payroll_action_id
203: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 240: pay_payroll_actions PA

236: (PA.effective_date, AA.assignment_id))
237: from per_all_people_f PE,
238: per_all_assignments_f SS,
239: pay_assignment_actions AA,
240: pay_payroll_actions PA
241: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
242: ('TRANSFER_PAYROLL_ACTION_ID')
243: and AA.payroll_action_id = PA.payroll_action_id
244: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 279: from pay_payroll_actions PA,

275: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
276: ('TRANSFER_WAGE_PLAN_CODE'),
277: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
278: ('TRANSFER_REPORT_CATEGORY')
279: from pay_payroll_actions PA,
280: pay_assignment_actions AA,
281: per_all_assignments_f SS,
282: per_all_people_f PE,
283: ff_archive_items fai,

Line 420: pay_payroll_actions ppa

416: select distinct 'JURISDICTION_CODE=C', context
417: from ff_archive_items fai,
418: ff_archive_item_contexts faic,
419: pay_assignment_actions paa,
420: pay_payroll_actions ppa
421: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
422: and ppa.payroll_action_id = paa.payroll_action_id
423: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
424: and fai.context1 = paa.assignment_action_id

Line 459: pay_payroll_actions ppa

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
463: -- ('TRANSFER_TRANS_LEGAL_CO_ID')

Line 483: pay_payroll_actions PA

479: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
480: 'TAX_UNIT_NAME=P' , substr(hou.name,1,81)
481: from hr_all_organization_units hou,
482: pay_assignment_actions AA,
483: pay_payroll_actions PA
484: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
485: ('TRANSFER_PAYROLL_ACTION_ID')
486: and PA.payroll_action_id = AA.payroll_action_id
487: and AA.tax_unit_id = hou.organization_id

Line 506: pay_payroll_actions PA

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')
509: and PA.payroll_action_id = AA.payroll_action_id
510: and AA.tax_unit_id = hou.organization_id

Line 524: pay_payroll_actions PA

520: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
521: from per_all_people_f PE,
522: per_all_assignments_f SS,
523: pay_assignment_actions AA,
524: pay_payroll_actions PA
525: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
526: ('TRANSFER_PAYROLL_ACTION_ID')
527: and AA.payroll_action_id = PA.payroll_action_id
528: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value