APPS.PA_EXPENDITURES_UTILS dependencies on HR_ORG_UNITS_NO_JOIN

Line 28: from hr_org_units_no_join o,

24: If G_Organization_Name is null OR
25: P_Organization_Id <> G_Organization_id Then
26: select tl.name
27: into G_Organization_Name
28: from hr_org_units_no_join o,
29: hr_all_organization_units_tl tl
30: where
31: o.organization_id(+) = P_Organization_Id
32: and o.organization_id = tl.organization_id(+)

Line 53: from hr_org_units_no_join o,

49: -- Fix for bug : 4005004
50: If G_Organization_id IS NULL then
51: select tl.name
52: into G_Organization_Name
53: from hr_org_units_no_join o,
54: hr_all_organization_units_tl tl
55: where
56: o.organization_id(+) = P_Organization_Id
57: and o.organization_id = tl.organization_id(+)

Line 70: from hr_org_units_no_join o,

66: elsif G_Organization_id <> P_Organization_Id then
67: if NVL(G_Organization_id_1, 0) <> P_Organization_Id then
68: select tl.name
69: into G_Organization_Name_1
70: from hr_org_units_no_join o,
71: hr_all_organization_units_tl tl
72: where
73: o.organization_id(+) = P_Organization_Id
74: and o.organization_id = tl.organization_id(+)

Line 117: from hr_org_units_no_join

113: If G_Organization_Name_US is null
114: OR P_Organization_Id <> NVL(G_Organization_id,-99) Then /* Added nvl() for bug 4240184*/
115: select name
116: into G_Organization_Name_US
117: from hr_org_units_no_join
118: where organization_id = P_Organization_Id;
119: G_Organization_id := P_Organization_Id; /* Added for bug 4240184*/
120: End If;
121:

Line 152: HR_ORG_UNITS_NO_JOIN O,

148: TL.NAME
149: INTO
150: X_ORG_NAME
151: FROM
152: HR_ORG_UNITS_NO_JOIN O,
153: HR_ALL_ORGANIZATION_UNITS_TL TL
154: WHERE
155: O.ORGANIZATION_ID(+) = P_ORG_ID
156: AND

Line 175: HR_ORG_UNITS_NO_JOIN O,

171: TL.NAME
172: INTO
173: X_ORG_NAME
174: FROM
175: HR_ORG_UNITS_NO_JOIN O,
176: HR_ALL_ORGANIZATION_UNITS_TL TL
177: WHERE
178: O.ORGANIZATION_ID(+) = P_ORG_ID
179: AND

Line 198: HR_ORG_UNITS_NO_JOIN O,

194: TL.NAME
195: INTO
196: X_ORG_NAME
197: FROM
198: HR_ORG_UNITS_NO_JOIN O,
199: HR_ALL_ORGANIZATION_UNITS_TL TL
200: WHERE
201: O.ORGANIZATION_ID(+) = P_ORG_ID
202: AND

Line 221: HR_ORG_UNITS_NO_JOIN O,

217: TL.NAME
218: INTO
219: X_ORG_NAME
220: FROM
221: HR_ORG_UNITS_NO_JOIN O,
222: HR_ALL_ORGANIZATION_UNITS_TL TL
223: WHERE
224: O.ORGANIZATION_ID(+) = P_ORG_ID
225: AND

Line 244: HR_ORG_UNITS_NO_JOIN O,

240: TL.NAME
241: INTO
242: X_ORG_NAME
243: FROM
244: HR_ORG_UNITS_NO_JOIN O,
245: HR_ALL_ORGANIZATION_UNITS_TL TL
246: WHERE
247: O.ORGANIZATION_ID(+) = P_ORG_ID
248: AND