APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_DB_HR_INT_PKG

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

3051:
3052: SELECT emp.employee_id,emp.full_name
3053: FROM per_employees_x emp
3054: WHERE emp.supervisor_id = p_supervisor_id
3055: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y';
3056:
3057: return TRUE;
3058:
3059: EXCEPTION

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

3190: OPEN p_employee_cursor FOR
3191:
3192: SELECT employee_id,supervisor_id,level-1
3193: FROM per_employees_x emp
3194: WHERE NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
3195: CONNECT BY prior employee_id = supervisor_id
3196: and level < 6
3197: START WITH employee_id = p_supervisor_id order by 2;
3198: */

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

3216: START WITH ass.pERSON_ID = p_supervisor_id
3217: ) H
3218: WHERE H.PERSON_ID = P.PERSON_ID AND
3219: TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND
3220: NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND
3221: P.EMPLOYEE_NUMBER IS NOT NULL
3222: ORDER BY 2;
3223:
3224:

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

3241: START WITH ass.pERSON_ID = p_supervisor_id
3242: ) H
3243: WHERE H.PERSON_ID = P.PERSON_ID AND
3244: TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND
3245: NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND
3246: P.EMPLOYEE_NUMBER IS NOT NULL
3247: ORDER BY 2;
3248:
3249: END IF;