APPS.PAY_US_MWR_REPORTING_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 48: from pay_payroll_actions ppa -- MWR payroll action

44: ** Driving Cursors file Generation
45: ******************************************************************/
46: cursor US_MWR_SETUP is
47: select 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id
48: from pay_payroll_actions ppa -- MWR payroll action
49: where ppa.payroll_action_id = Pay_Magtape_Generic.Get_Parameter_Value(
50: 'TRANSFER_PAYROLL_ACTION_ID'); -- MWR payroll action
51:
52:

Line 63: PAY_PAYROLL_ACTIONS PPA2, -- MWR payroll action

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

Line 66: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action

62: from
63: PAY_PAYROLL_ACTIONS PPA2, -- MWR payroll action
64: PAY_ASSIGNMENT_ACTIONS PAA2, -- MWR assignment action
65: PAY_ASSIGNMENT_ACTIONS PAA1, -- SQWL assignment action
66: PAY_PAYROLL_ACTIONS PPA1, -- SQWL payroll action
67: PAY_STATE_RULES PSR,
68: HR_ORGANIZATION_INFORMATION HOI1, -- gre / legal entity classification
69: HR_ORGANIZATION_INFORMATION HOI2, -- Federal employer Identification
70: HR_ORGANIZATION_INFORMATION HOI3 -- state SUI code.