APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 195: PER_ALL_ASSIGNMENTS_F ASS,

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,
199: PER_PAY_BASES PPB,

Line 247: PER_ALL_ASSIGNMENTS_F ASS,

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,
251: PER_PAY_BASES PPB,

Line 347: PER_ALL_ASSIGNMENTS_F ASS,

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,
351: PER_PAY_BASES PPB,

Line 401: PER_ALL_ASSIGNMENTS_F ASS,

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,
405: PER_PAY_BASES PPB,