DBA Data[Home] [Help]

APPS.PAY_DK_TAX_CARD_REQUEST_PKG dependencies on HR_ORGANIZATION_UNITS

Line 29: FROM HR_ORGANIZATION_UNITS hou1

25: CURSOR get_org_details IS
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

Line 54: , HR_ORGANIZATION_UNITS hou

50: FROM per_all_assignments_f PAA
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