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 100: pay_payroll_actions PA

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

Line 131: from pay_payroll_actions PA,

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

Line 197: pay_payroll_actions PA

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

Line 242: from pay_payroll_actions PA,

238: 'TRANSFER_WAGE_PLAN_CODE=P',pay_magtape_generic.get_parameter_value
239: ('TRANSFER_WAGE_PLAN_CODE'),
240: 'TRANSFER_REPORT_FORMAT=P', pay_magtape_generic.get_parameter_value
241: ('TRANSFER_REPORT_CATEGORY')
242: from pay_payroll_actions PA,
243: pay_assignment_actions AA,
244: per_all_assignments_f SS,
245: per_all_people_f PE,
246: ff_archive_items fai,

Line 383: pay_payroll_actions ppa

379: select distinct 'JURISDICTION_CODE=C', context
380: from ff_archive_items fai,
381: ff_archive_item_contexts faic,
382: pay_assignment_actions paa,
383: pay_payroll_actions ppa
384: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
385: and ppa.payroll_action_id = paa.payroll_action_id
386: and paa.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID')
387: and fai.context1 = paa.assignment_action_id

Line 422: pay_payroll_actions ppa

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

Line 446: pay_payroll_actions PA

442: 'DATE_EARNED=C' , fnd_date.date_to_canonical(PA.effective_date),
443: 'TAX_UNIT_NAME=P' , hou.name
444: from hr_all_organization_units hou,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: where AA.payroll_action_id = pay_magtape_generic.get_parameter_value
448: ('TRANSFER_PAYROLL_ACTION_ID')
449: and PA.payroll_action_id = AA.payroll_action_id
450: and AA.tax_unit_id = hou.organization_id

Line 467: pay_payroll_actions PA

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

Line 485: pay_payroll_actions PA

481: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned(PA.effective_date, AA.assignment_id))
482: from per_all_people_f PE,
483: per_all_assignments_f SS,
484: pay_assignment_actions AA,
485: pay_payroll_actions PA
486: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
487: ('TRANSFER_PAYROLL_ACTION_ID')
488: and AA.payroll_action_id = PA.payroll_action_id
489: and AA.tax_unit_id = pay_magtape_generic.get_parameter_value