APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 194: FROM PER_ALL_PEOPLE_F PEO,

190: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, '13', DECODE(PEO.SEX, 'M', 1, NULL), NULL)))) TMRMEN,
191: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, '13', DECODE(PEO.SEX, 'F', 1, NULL), NULL)))) TMRWMEN
192: Commented for bug#11736960 ends */
193: --
194: FROM PER_ALL_PEOPLE_F PEO,
195: PER_ALL_ASSIGNMENTS_F ASS,
196: PER_ASSIGNMENT_STATUS_TYPES AST,
197: PER_JOBS JOB,
198: PER_PAY_PROPOSALS PPP,

Line 246: FROM PER_ALL_PEOPLE_F PEO,

242: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
243: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
244: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
245: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN
246: FROM PER_ALL_PEOPLE_F PEO,
247: PER_ALL_ASSIGNMENTS_F ASS,
248: PER_ASSIGNMENT_STATUS_TYPES AST,
249: PER_JOBS JOB,
250: PER_PAY_PROPOSALS PPP,

Line 346: FROM PER_ALL_PEOPLE_F PEO,

342: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, '13', DECODE(PEO.SEX, 'M', 1, NULL), NULL)))) TMRMEN,
343: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, '13', DECODE(PEO.SEX, 'F', 1, NULL), NULL)))) TMRWMEN
344: Commented for bug#11736960 ends */
345: --
346: FROM PER_ALL_PEOPLE_F PEO,
347: PER_ALL_ASSIGNMENTS_F ASS,
348: PER_ASSIGNMENT_STATUS_TYPES AST,
349: PER_JOBS JOB,
350: PER_PAY_PROPOSALS PPP,

Line 400: FROM PER_ALL_PEOPLE_F PEO,

396: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
397: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
398: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN
399:
400: FROM PER_ALL_PEOPLE_F PEO,
401: PER_ALL_ASSIGNMENTS_F ASS,
402: PER_ASSIGNMENT_STATUS_TYPES AST,
403: PER_JOBS JOB,
404: PER_PAY_PROPOSALS PPP,