APPS.AP_WEB_CREDIT_CARD_WF dependencies on PER_EMPLOYEES_X

Line 2979: FROM per_employees_x emp

2975:
2976: OPEN p_employee_cursor FOR
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;

Line 3013: l_employee_name per_employees_x.FULL_NAME%TYPE;

3009: p_total_amount OUT NOCOPY NUMBER) IS
3010: -----------------------------------------------
3011: l_supervisor_id NUMBER;
3012: l_employee_cursor EmployeeCursor;
3013: l_employee_name per_employees_x.FULL_NAME%TYPE;
3014: l_total_amount NUMBER := 0;
3015: l_total_outstanding NUMBER;
3016: l_total_amt_outstanding NUMBER;
3017: l_total_dispute NUMBER;

Line 3119: FROM per_employees_x emp

3115: /*
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;

Line 3217: l_employee_name per_employees_x.full_name%TYPE;

3213: p_total_amount OUT NOCOPY NUMBER) IS
3214: -----------------------------------------------
3215: l_supervisor_id NUMBER;
3216: l_employee_cursor EmployeeCursor;
3217: l_employee_name per_employees_x.full_name%TYPE;
3218: l_direct_manager_name per_employees_x.full_name%TYPE; --Direct Report
3219: l_total_amount NUMBER := 0;
3220: l_total_outstanding NUMBER;
3221: l_total_amt_outstanding NUMBER;

Line 3218: l_direct_manager_name per_employees_x.full_name%TYPE; --Direct Report

3214: -----------------------------------------------
3215: l_supervisor_id NUMBER;
3216: l_employee_cursor EmployeeCursor;
3217: l_employee_name per_employees_x.full_name%TYPE;
3218: l_direct_manager_name per_employees_x.full_name%TYPE; --Direct Report
3219: l_total_amount NUMBER := 0;
3220: l_total_outstanding NUMBER;
3221: l_total_amt_outstanding NUMBER;
3222: l_total_dispute NUMBER;