APPS.PQH_PQIPED7_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 173: FROM HR_ALL_ORGANIZATION_UNITS

169: AND ASS.JOB_ID = JOB.JOB_ID
170: AND ASS.ASSIGNMENT_TYPE = 'E'
171: AND ASS.ORGANIZATION_ID IN
172: (SELECT ORGANIZATION_ID
173: FROM HR_ALL_ORGANIZATION_UNITS
174: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
175: ;
176: CURSOR GET_LINE1_TMRACES_COUNTS IS
177: SELECT COUNT(DECODE(PEI.PEI_INFORMATION5, '2', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,

Line 241: FROM HR_ALL_ORGANIZATION_UNITS

237: AND ASS.JOB_ID = JOB.JOB_ID
238: AND ASS.ASSIGNMENT_TYPE = 'E'
239: AND ASS.ORGANIZATION_ID IN
240: (SELECT ORGANIZATION_ID
241: FROM HR_ALL_ORGANIZATION_UNITS
242: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
243: ;
244: CURSOR GET_LINE2_COUNTS IS
245: SELECT '2' LINE,

Line 295: FROM HR_ALL_ORGANIZATION_UNITS

291: AND ASS.JOB_ID = JOB.JOB_ID
292: AND ASS.ASSIGNMENT_TYPE = 'E'
293: AND ASS.ORGANIZATION_ID IN
294: (SELECT ORGANIZATION_ID
295: FROM HR_ALL_ORGANIZATION_UNITS
296: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
297: GROUP BY HL.LOOKUP_CODE;
298: CURSOR GET_TMR_LINE2_COUNTS(C_LOOKUP_CODE IN VARCHAR2) IS
299: SELECT COUNT(DECODE(PEI.PEI_INFORMATION5, '2', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) BNHMEN,

Line 363: FROM HR_ALL_ORGANIZATION_UNITS

359: AND ASS.JOB_ID = JOB.JOB_ID
360: AND ASS.ASSIGNMENT_TYPE = 'E'
361: AND ASS.ORGANIZATION_ID IN
362: (SELECT ORGANIZATION_ID
363: FROM HR_ALL_ORGANIZATION_UNITS
364: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
365: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
366:
367: begin