DBA Data[Home] [Help]

APPS.PQH_PQIPED7_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 196: PER_ASSIGNMENT_STATUS_TYPES AST,

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,
200: HR_LOOKUPS HL

Line 248: PER_ASSIGNMENT_STATUS_TYPES AST,

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

Line 348: PER_ASSIGNMENT_STATUS_TYPES AST,

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,
352: HR_LOOKUPS HL

Line 402: PER_ASSIGNMENT_STATUS_TYPES AST,

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