APPS.PAY_US_MWR_REPORTING_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 53: from pay_payroll_actions ppa -- MWR payroll action

49: ** Driving Cursors file Generation
50: ******************************************************************/
51: cursor US_MWR_SETUP is
52: select 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id
53: from pay_payroll_actions ppa -- MWR payroll action
54: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(
55: 'TRANSFER_PAYROLL_ACTION_ID'); -- MWR payroll action
56:
57:

Line 68: PAY_PAYROLL_ACTIONS PPA2, -- MWR payroll action

64: 'TRANSFER_SUI_CODE=P', hoi3.org_information2, -- STATE SUI code.
65: 'TRANSFER_REPORTING_YEAR=P', to_char(ppa1.effective_date,'yyyy'),
66: 'TRANSFER_OUTPUT_QTR=P', to_char(ppa2.effective_date,'Q')
67: from
68: PAY_PAYROLL_ACTIONS PPA2, -- MWR payroll action
69: PAY_ASSIGNMENT_ACTIONS PAA2, -- MWR assignment action
70: PAY_ASSIGNMENT_ACTIONS PAA1, -- SQWL assignment action
71: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
72: PAY_STATE_RULES PSR,

Line 71: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action

67: from
68: PAY_PAYROLL_ACTIONS PPA2, -- MWR payroll action
69: PAY_ASSIGNMENT_ACTIONS PAA2, -- MWR assignment action
70: PAY_ASSIGNMENT_ACTIONS PAA1, -- SQWL assignment action
71: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
72: PAY_STATE_RULES PSR,
73: HR_ORGANIZATION_INFORMATION HOI1, -- gre / legal entity classification
74: HR_ORGANIZATION_INFORMATION HOI2, -- Federal employer Identification
75: HR_ORGANIZATION_INFORMATION HOI3 -- state SUI code.