APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_DB_HR_INT_PKG

Line 2981: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y';

2977:
2978: SELECT emp.employee_id,emp.full_name
2979: FROM per_employees_x emp
2980: WHERE emp.supervisor_id = p_supervisor_id
2981: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y';
2982:
2983: return TRUE;
2984:
2985: EXCEPTION

Line 3120: WHERE NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

3116: OPEN p_employee_cursor FOR
3117:
3118: SELECT employee_id,supervisor_id,level-1
3119: FROM per_employees_x emp
3120: WHERE NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
3121: CONNECT BY prior employee_id = supervisor_id
3122: and level < 6
3123: START WITH employee_id = p_supervisor_id order by 2;
3124: */

Line 3147: NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND

3143: START WITH ass.pERSON_ID = p_supervisor_id
3144: ) H
3145: WHERE H.PERSON_ID = P.PERSON_ID AND
3146: TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND
3147: NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND
3148: P.EMPLOYEE_NUMBER IS NOT NULL
3149: ORDER BY 2;
3150:
3151:

Line 3172: NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND

3168: START WITH ass.pERSON_ID = p_supervisor_id
3169: ) H
3170: WHERE H.PERSON_ID = P.PERSON_ID AND
3171: TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND
3172: NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND
3173: P.EMPLOYEE_NUMBER IS NOT NULL
3174: ORDER BY 2;
3175:
3176: END IF;