DBA Data[Home] [Help]

APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_JOBS

Line 142: PER_JOBS JOB,

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,
145: HR_LOOKUPS HL
146: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 192: PER_JOBS JOB,

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,
195: HR_LOOKUPS HL,
196: PER_PEOPLE_EXTRA_INFO PEI

Line 264: PER_JOBS JOB,

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,
267: HR_LOOKUPS HL
268: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 314: PER_JOBS JOB,

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,
317: HR_LOOKUPS HL,
318: PER_PEOPLE_EXTRA_INFO PEI