DBA Data[Home] [Help]

APPS.PAY_US_1099R_MAG_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 153: from hr_organization_information hoi,

149: 'VENDOR_ZIP=P', nvl(hoi.org_information16,' '),
150: 'VENDOR_CONTACT_NAME=P', nvl(hoi.org_information17,' '),
151: 'VENDOR_CONTACT_PHONE=P', nvl(hoi.org_information18,' '),
152: 'VENDOR_CONTACT_EMAIL=P', nvl(hoi.org_information19,' ')
153: from hr_organization_information hoi,
154: ff_contexts ffc,
155: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
156: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE
157: ff_archive_item_contexts ffaic,

Line 211: from hr_organization_information hoi,

207: 'VENDOR_ZIP=P', nvl(hoi.org_information16,' '),
208: 'VENDOR_CONTACT_NAME=P', nvl(hoi.org_information17,' '),
209: 'VENDOR_CONTACT_PHONE=P', nvl(hoi.org_information18, ' '),
210: 'VENDOR_CONTACT_EMAIL=P', nvl(hoi.org_information19,' ')
211: from hr_organization_information hoi,
212: pay_state_rules psr,
213: ff_contexts ffc,
214: ff_user_entities fue, -- A_US_1099R_TRANSMITTER_INDICATOR
215: ff_user_entities fue2, -- A_US_1099R_TRANSMITTER_CODE

Line 268: from -- hr_organization_information hoi,

264: select 'TAX_UNIT_ID=C' , ffaic2.context, -- hoi.organization_id,
265: 'PAYROLL_ACTION_ID=C' , ffai2.context1,
266: 'TAX_UNIT_ID=P' , ffaic2.context, -- hoi.organization_id,
267: 'TRANSFER_TAX_UNIT_NAME=P', substr(ffai3.value,1,80) -- hou.name Bug# 14286448 Gre length issue
268: from -- hr_organization_information hoi,
269: -- hr_organization_units hou,
270: ff_contexts ffc,
271: ff_user_entities ffue,
272: ff_user_entities ffue2,

Line 517: hr_organization_information hoi

513: -- for payers participating in Combined Filing.
514: Cursor US_1099R_State_Process IS
515: select distinct 'TRANSFER_STATE_NAME=P', hlk.lookup_code
516: from fnd_common_lookups hlk,
517: hr_organization_information hoi
518: where hoi.organization_id = Pay_Magtape_Generic.Get_Parameter_Value
519: ('TRANSFER_TRANS_LEGAL_CO_ID')
520: and hoi.org_information4 = 'Y'
521: and hoi.org_information_context = '1099R Magnetic Report Rules'

Line 565: hr_organization_information HOI,

561: 'PAYROLL_ACTION_ID=C', PPA.payroll_action_id,
562: 'TRANSFER_LOCALITY_CODE=P', 'DUMMY',
563: 'BUSINESS_GROUP_ID=C',PPA.business_group_id
564: FROM pay_state_rules SR,
565: hr_organization_information HOI,
566: pay_payroll_actions PPA,
567: pay_payroll_actions PPA1
568: WHERE PPA1.payroll_action_id = pay_magtape_generic.get_parameter_value
569: ('TRANSFER_PAYROLL_ACTION_ID')