APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 139: FROM PER_ALL_PEOPLE_F PEO,

135: 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, 'M', 1, NULL), NULL)))) WNHMEN,
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,

Line 189: FROM PER_ALL_PEOPLE_F PEO,

185: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
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,

Line 261: FROM PER_ALL_PEOPLE_F PEO,

257: 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, 'M', 1, NULL), NULL)))) WNHMEN,
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,

Line 311: FROM PER_ALL_PEOPLE_F PEO,

307: COUNT(DECODE(PEI.PEI_INFORMATION5, '1', DECODE(PEO.SEX, 'M', 1, NULL), NULL)) WNHMEN,
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,