DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 38: hr_all_organization_units_tl corptl,

34: 'B_RECORDS=P', to_char(g_b_records),
35: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
36: from hr_organization_information hoi3,
37: hr_locations_all loc,
38: hr_all_organization_units_tl corptl,
39: hr_organization_units corp,
40: hr_organization_information hoi2,
41: hr_organization_information hoi1,
42: hr_all_organization_units_tl bptl,

Line 42: hr_all_organization_units_tl bptl,

38: hr_all_organization_units_tl corptl,
39: hr_organization_units corp,
40: hr_organization_information hoi2,
41: hr_organization_information hoi1,
42: hr_all_organization_units_tl bptl,
43: hr_organization_units bp
44: where bp.organization_id = g_business_place_id
45: and bptl.organization_id = bp.organization_id
46: and bptl.language = userenv('LANG')

Line 70: hr_all_organization_units_tl bptl2,

66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,
70: hr_all_organization_units_tl bptl2,
71: hr_organization_units bp2,
72: hr_organization_information hoi1,
73: hr_organization_units bp1
74: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923