DBA Data[Home] [Help]

APPS.PAY_US_MAGW2_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 88: hr_organization_information HOI,

84: 'TRANSFER_COUNTY=P', '-1',
85: 'TRANSFER_2678_FILER=P', 'N',
86: 'PAYROLL_ACTION_ID=C', PPA.payroll_action_id
87: FROM pay_state_rules SR,
88: hr_organization_information HOI,
89: pay_payroll_actions PPA
90: WHERE HOI.organization_id =
91: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
92: AND SR.state_code =

Line 108: FROM hr_organization_information HOI,

104: 'TRANSFER_SCHOOL_DISTRICT=P', '-1',
105: 'TRANSFER_COUNTY=P', '-1',
106: 'TRANSFER_2678_FILER=P', HOI.org_information8,
107: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id -- payroll_action_id of YREND
108: FROM hr_organization_information HOI,
109: pay_payroll_actions PPA
110: WHERE HOI.organization_id =
111: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
112: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'