APPS.AP_APXCCOUT_XMLP_PKG dependencies on PER_EMPLOYEES_X

Line 145: from per_employees_x emp1 -- Bug 3176205: Changed HR view to include all employees(inactive also) and exclude contingent workers.

141: END IF;
142: IF (P_EMPLOYEE IS NOT NULL) THEN
143: IF (P_INCLUDE_DIRECTS = 'Y') THEN
144: LP_EMP_MGR := ' and (ac.employee_id in (select distinct employee_id
145: from per_employees_x emp1 -- Bug 3176205: Changed HR view to include all employees(inactive also) and exclude contingent workers.
146: where emp1.supervisor_id = ' || P_EMPLOYEE || ')
147: OR ac.employee_id = ' || P_EMPLOYEE || ') ';
148: LP_EMP_MGR1 := ' and (ac.employee_id in (select distinct person_id
149: from per_assignments_f pera1

Line 495: PER_EMPLOYEES_X

491: SELECT
492: DISTINCT
493: EMPLOYEE_ID
494: FROM
495: PER_EMPLOYEES_X
496: WHERE SUPERVISOR_ID = P_EMPLOYEE )
497: AND P_INCLUDE_DIRECTS = 'Y'
498: UNION ALL
499: SELECT

Line 613: PER_EMPLOYEES_X

609: SELECT
610: DISTINCT
611: EMPLOYEE_ID
612: FROM
613: PER_EMPLOYEES_X
614: WHERE SUPERVISOR_ID = P_EMPLOYEE )
615: AND P_INCLUDE_DIRECTS = 'Y'
616: UNION ALL
617: SELECT

Line 762: PER_EMPLOYEES_X

758: SELECT
759: DISTINCT
760: EMPLOYEE_ID
761: FROM
762: PER_EMPLOYEES_X
763: WHERE SUPERVISOR_ID = P_EMPLOYEE )
764: AND P_INCLUDE_DIRECTS = 'Y'
765: AND ERH.EXPENSE_CURRENT_APPROVER_ID is not null
766: GROUP BY

Line 927: PER_EMPLOYEES_X

923: SELECT
924: FULL_NAME
925: INTO L_SUPERVISOR_NAME
926: FROM
927: PER_EMPLOYEES_X
928: WHERE EMPLOYEE_ID = SUPERVISOR_ID1;
929: CP_SUPERVISOR_NAME := L_SUPERVISOR_NAME;
930: RETURN (CP_SUPERVISOR_NAME);
931: EXCEPTION

Line 966: PER_EMPLOYEES_X

962: SELECT
963: FULL_NAME
964: INTO L_SUPERVISOR_NAME
965: FROM
966: PER_EMPLOYEES_X
967: WHERE EMPLOYEE_ID = AGE_SUPERVISOR_ID;
968: CP_AGE_SUP_NAME := L_SUPERVISOR_NAME;
969: RETURN (NULL);
970: EXCEPTION

Line 983: PER_EMPLOYEES_X

979: SELECT
980: FULL_NAME
981: INTO L_EMPLOYEE_NAME
982: FROM
983: PER_EMPLOYEES_X
984: WHERE EMPLOYEE_ID = AGE_EMPLOYEE_ID;
985: CP_AGE_EMP_NAME := L_EMPLOYEE_NAME || '/' || AGE_EMP_STATUS;
986: RETURN NULL;
987: END CF_AGE_AMP_NAMEFORMULA;

Line 996: PER_EMPLOYEES_X

992: SELECT
993: FULL_NAME
994: INTO L_EMP_NAME
995: FROM
996: PER_EMPLOYEES_X
997: WHERE EMPLOYEE_ID = EMPLOYEE_ID1;
998: CP_EMP_NAME_SUMM := L_EMP_NAME;
999: RETURN NULL;
1000: END CF_EMP_NAME_SUMMFORMULA;

Line 1163: PER_EMPLOYEES_X EMP1

1159: SELECT
1160: DISTINCT
1161: EMPLOYEE_ID
1162: FROM
1163: PER_EMPLOYEES_X EMP1
1164: WHERE EMP1.SUPERVISOR_ID = P_EMPLOYEE )
1165: OR AC.EMPLOYEE_ID = P_EMPLOYEE )
1166: AND ( TRUNC(SYSDATE) - ( CCT.POSTED_DATE + DECODE(CCT.CATEGORY
1167: ,'DISPUTED'