DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING1 dependencies on HR_ORGANIZATION_INFORMATION

Line 96: hr_organization_information HOI,

92: 'PAYROLL_ACTION_ID=C', PPA.payroll_action_id,
93: 'BUSINESS_GROUP_ID=C',PPA.business_group_id,
94: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
95: FROM pay_state_rules SR,
96: hr_organization_information HOI,
97: pay_payroll_actions PPA,
98: pay_payroll_actions PPA1
99: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
100: ('TRANSFER_PAYROLL_ACTION_ID')

Line 147: FROM hr_organization_information HOI,

143: 'TRANSFER_COUNTY=P', '-1',
144: 'TRANSFER_2678_FILER=P', HOI.org_information8,
145: 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id, -- payroll_action_id of YREND
146: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY'
147: FROM hr_organization_information HOI,
148: pay_payroll_actions PPA
149: WHERE HOI.organization_id =
150: pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID')
151: AND pay_magtape_generic.get_parameter_value('TRANSFER_STATE') = 'FED'