APPS.PAY_DK_TAX_CARD_REQUEST_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 30: , HR_ORGANIZATION_INFORMATION hoi1

26: SELECT 'ORGANIZATION_NAME=P',hou1.name
27: ,'TRANSFER_CVRNO=P',hoi2.org_information1
28: ,'ORGANIZATION_ADDR=P', loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3
29: FROM HR_ORGANIZATION_UNITS hou1
30: , HR_ORGANIZATION_INFORMATION hoi1
31: , HR_ORGANIZATION_INFORMATION hoi2
32: , HR_LOCATIONS loc
33: , PAY_PAYROLL_ACTIONS ppa
34: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 31: , HR_ORGANIZATION_INFORMATION hoi2

27: ,'TRANSFER_CVRNO=P',hoi2.org_information1
28: ,'ORGANIZATION_ADDR=P', loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3
29: FROM HR_ORGANIZATION_UNITS hou1
30: , HR_ORGANIZATION_INFORMATION hoi1
31: , HR_ORGANIZATION_INFORMATION hoi2
32: , HR_LOCATIONS loc
33: , PAY_PAYROLL_ACTIONS ppa
34: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
35: and hou1.business_group_id = ppa.BUSINESS_GROUP_ID

Line 55: , HR_ORGANIZATION_INFORMATION hoi1

51: , per_all_people_f PAP
52: , hr_soft_coding_keyflex SCL
53: , pay_payroll_actions PPA
54: , HR_ORGANIZATION_UNITS hou
55: , HR_ORGANIZATION_INFORMATION hoi1
56: , HR_ORGANIZATION_INFORMATION hoi2
57: WHERE PPA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
58: and PAA.business_group_id = PPA.business_group_id
59: AND PAP.per_information_category ='DK'

Line 56: , HR_ORGANIZATION_INFORMATION hoi2

52: , hr_soft_coding_keyflex SCL
53: , pay_payroll_actions PPA
54: , HR_ORGANIZATION_UNITS hou
55: , HR_ORGANIZATION_INFORMATION hoi1
56: , HR_ORGANIZATION_INFORMATION hoi2
57: WHERE PPA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
58: and PAA.business_group_id = PPA.business_group_id
59: AND PAP.per_information_category ='DK'
60: AND PAA.PERSON_ID = PAP.PERSON_ID