APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 99: pay_assignment_actions AA,

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')
103: and PA.payroll_action_id = AA.payroll_action_id

Line 132: pay_assignment_actions AA,

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
136: ('TRANSFER_PAYROLL_ACTION_ID')

Line 145: FROM pay_assignment_actions paa,

141: and hoi.organization_id = AA.tax_unit_id
142: and hoi.org_information1 = pay_magtape_generic.get_parameter_value
143: ('TRANSFER_STATE')
144: and EXISTS (SELECT /*+ ordered */NULL
145: FROM pay_assignment_actions paa,
146: ff_archive_items fai,
147: ff_user_entities fue
148: WHERE fai.context1 = paa.assignment_action_id
149: AND paa.payroll_action_id = AA.payroll_action_id

Line 196: pay_assignment_actions AA,

192: 'DATE_EARNED=C' ,fnd_date.date_to_canonical(pay_magtape_generic.date_earned
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

Line 243: pay_assignment_actions AA,

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,
247: ff_user_entities fue

Line 382: pay_assignment_actions paa,

378: */
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')

Line 445: pay_assignment_actions AA,

441: 'TAX_UNIT_ID=P' , AA.tax_unit_id,
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

Line 466: pay_assignment_actions AA,

462: 'TAX_UNIT_NAME=P' , hou.name,
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

Line 484: pay_assignment_actions AA,

480: 'ASSIGNMENT_ID=P' , AA.assignment_id, /* Bug 976472 */
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