APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 140: PER_ALL_ASSIGNMENTS_F ASS,

136: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)))) WNHWMEN,
137: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, NULL, DECODE(PEO.SEX, 'M', 1, NULL), NULL)))) URMEN,
138: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, NULL, DECODE(PEO.SEX, 'F', 1, NULL), NULL)))) URWMEN
139: FROM PER_ALL_PEOPLE_F PEO,
140: PER_ALL_ASSIGNMENTS_F ASS,
141: PER_ASSIGNMENT_STATUS_TYPES AST,
142: PER_JOBS JOB,
143: PER_PAY_PROPOSALS PPP,
144: PER_PAY_BASES PPB,

Line 190: PER_ALL_ASSIGNMENTS_F ASS,

186: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
187: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
188: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN
189: FROM PER_ALL_PEOPLE_F PEO,
190: PER_ALL_ASSIGNMENTS_F ASS,
191: PER_ASSIGNMENT_STATUS_TYPES AST,
192: PER_JOBS JOB,
193: PER_PAY_PROPOSALS PPP,
194: PER_PAY_BASES PPB,

Line 262: PER_ALL_ASSIGNMENTS_F ASS,

258: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)))) WNHWMEN,
259: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, NULL, DECODE(PEO.SEX, 'M', 1, NULL), NULL)))) URMEN,
260: COUNT(DECODE(PQH_NR_ALIEN_PKG.GET_COUNT_NR_ALIEN(PEO.PERSON_ID, P_REPORT_DATE), NULL, (DECODE(PEO.PER_INFORMATION1, NULL, DECODE(PEO.SEX, 'F', 1, NULL), NULL)))) URWMEN
261: FROM PER_ALL_PEOPLE_F PEO,
262: PER_ALL_ASSIGNMENTS_F ASS,
263: PER_ASSIGNMENT_STATUS_TYPES AST,
264: PER_JOBS JOB,
265: PER_PAY_PROPOSALS PPP,
266: PER_PAY_BASES PPB,

Line 312: PER_ALL_ASSIGNMENTS_F ASS,

308: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'F', 1, NULL), NULL)) WNHWMEN,
309: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'M', 1, NULL), NULL)) URMEN,
310: COUNT(DECODE(PEI.PEI_INFORMATION5, NULL, DECODE(PEO.SEX, 'F', 1, NULL), NULL)) URWMEN
311: FROM PER_ALL_PEOPLE_F PEO,
312: PER_ALL_ASSIGNMENTS_F ASS,
313: PER_ASSIGNMENT_STATUS_TYPES AST,
314: PER_JOBS JOB,
315: PER_PAY_PROPOSALS PPP,
316: PER_PAY_BASES PPB,