DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 40: hr_all_organization_units_tl corptl,

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

Line 44: hr_all_organization_units_tl bptl,

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

Line 73: hr_all_organization_units_tl bptl2,

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