DBA Data[Home] [Help]

APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_JOBS

Line 197: PER_JOBS JOB,

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

Line 249: PER_JOBS JOB,

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,
252: HR_LOOKUPS HL,
253: PER_PEOPLE_EXTRA_INFO PEI

Line 349: PER_JOBS JOB,

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

Line 403: PER_JOBS JOB,

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,
406: HR_LOOKUPS HL,
407: PER_PEOPLE_EXTRA_INFO PEI