APPS.PAY_US_1099R_MAG_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 147: from hr_organization_information hoi,

143: 'VENDOR_ZIP=P', hoi.org_information16,
144: 'VENDOR_CONTACT_NAME=P', hoi.org_information17,
145: 'VENDOR_CONTACT_PHONE=P', hoi.org_information18,
146: 'VENDOR_CONTACT_EMAIL=P', hoi.org_information19
147: from hr_organization_information hoi,
148: ff_contexts ffc,
149: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
150: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
151: ff_archive_item_contexts ffaic,

Line 205: from hr_organization_information hoi,

201: 'VENDOR_ZIP=P', hoi.org_information16,
202: 'VENDOR_CONTACT_NAME=P', hoi.org_information17,
203: 'VENDOR_CONTACT_PHONE=P', hoi.org_information18,
204: 'VENDOR_CONTACT_EMAIL=P', hoi.org_information19
205: from hr_organization_information hoi,
206: pay_state_rules psr,
207: ff_contexts ffc,
208: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
209: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE

Line 262: from -- hr_organization_information hoi,

258: select 'TAX_UNIT_ID=C' , ffaic2.context, -- hoi.organization_id,
259: 'PAYROLL_ACTION_ID=C' , ffai2.context1,
260: 'TAX_UNIT_ID=P' , ffaic2.context, -- hoi.organization_id,
261: 'TRANSFER_TAX_UNIT_NAME=P', ffai3.value -- hou.name
262: from -- hr_organization_information hoi,
263: -- hr_organization_units hou,
264: ff_contexts ffc,
265: ff_user_entities ffue,
266: ff_user_entities ffue2,

Line 511: hr_organization_information hoi

507: -- for payers participating in Combined Filing.
508: Cursor US_1099R_State_Process IS
509: select distinct 'TRANSFER_STATE_NAME=P', hlk.lookup_code
510: from fnd_common_lookups hlk,
511: hr_organization_information hoi
512: where hoi.organization_id = Pay_Magtape_Generic.Get_Parameter_Value
513: ('TRANSFER_TRANS_LEGAL_CO_ID')
514: and hoi.org_information4 = 'Y'
515: and hoi.org_information_context = '1099R Magnetic Report Rules'

Line 554: hr_organization_information HOI,

550: 'PAYROLL_ACTION_ID=C', PPA.payroll_action_id,
551: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY',
552: 'BUSINESS_GROUP_ID=C',PPA.business_group_id
553: FROM pay_state_rules SR,
554: hr_organization_information HOI,
555: pay_payroll_actions PPA,
556: pay_payroll_actions PPA1
557: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
558: ('TRANSFER_PAYROLL_ACTION_ID')