APPS.AP_WEB_CREDIT_CARD_WF dependencies on PER_EMPLOYEES_X

Line 3053: FROM per_employees_x emp

3049:
3050: OPEN p_employee_cursor FOR
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;

Line 3087: l_employee_name per_employees_x.FULL_NAME%TYPE;

3083: p_total_amount OUT NOCOPY NUMBER) IS
3084: -----------------------------------------------
3085: l_supervisor_id NUMBER;
3086: l_employee_cursor EmployeeCursor;
3087: l_employee_name per_employees_x.FULL_NAME%TYPE;
3088: l_total_amount NUMBER := 0;
3089: l_total_outstanding NUMBER;
3090: l_total_amt_outstanding NUMBER;
3091: l_total_dispute NUMBER;

Line 3193: FROM per_employees_x emp

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

Line 3290: l_employee_name per_employees_x.full_name%TYPE;

3286: p_total_amount OUT NOCOPY NUMBER) IS
3287: -----------------------------------------------
3288: l_supervisor_id NUMBER;
3289: l_employee_cursor EmployeeCursor;
3290: l_employee_name per_employees_x.full_name%TYPE;
3291: l_direct_manager_name per_employees_x.full_name%TYPE; --Direct Report
3292: l_total_amount NUMBER := 0;
3293: l_total_outstanding NUMBER;
3294: l_total_amt_outstanding NUMBER;

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

3287: -----------------------------------------------
3288: l_supervisor_id NUMBER;
3289: l_employee_cursor EmployeeCursor;
3290: l_employee_name per_employees_x.full_name%TYPE;
3291: l_direct_manager_name per_employees_x.full_name%TYPE; --Direct Report
3292: l_total_amount NUMBER := 0;
3293: l_total_outstanding NUMBER;
3294: l_total_amt_outstanding NUMBER;
3295: l_total_dispute NUMBER;