eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_CREDIT_CARD_WF dependencies on PER_PEOPLE_F

Line 2534: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

2530:
2531: l_employee_cursor EmployeeCursor;
2532: l_supervisor_id NUMBER;
2533:
2534: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2535:
2536: l_total_outstanding NUMBER;
2537: l_total_amt_outstanding NUMBER;
2538: l_total_dispute NUMBER;

Line 2785: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;

2781:
2782: l_employee_cursor EmployeeCursor;
2783: l_supervisor_id NUMBER;
2784:
2785: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
2786: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2787:
2788: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2789: l_count NUMBER := 0; --Direct Report

Line 2786: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

2782: l_employee_cursor EmployeeCursor;
2783: l_supervisor_id NUMBER;
2784:
2785: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
2786: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2787:
2788: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2789: l_count NUMBER := 0; --Direct Report
2790:

Line 2788: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report

2784:
2785: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
2786: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2787:
2788: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2789: l_count NUMBER := 0; --Direct Report
2790:
2791: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2792: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

Line 2791: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

2787:
2788: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2789: l_count NUMBER := 0; --Direct Report
2790:
2791: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2792: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2793:
2794: l_total_outstanding NUMBER;
2795: l_total_amt_outstanding NUMBER;

Line 2792: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

2788: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2789: l_count NUMBER := 0; --Direct Report
2790:
2791: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2792: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2793:
2794: l_total_outstanding NUMBER;
2795: l_total_amt_outstanding NUMBER;
2796: l_total_dispute NUMBER;

Line 2805: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE; --Bug 3337443

2801: l_gross_amount NUMBER := 0;
2802:
2803:
2804: l_final_manager_id NUMBER; --bug 3337443
2805: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE; --Bug 3337443
2806:
2807: l_level NUMBER := 0; --Bug 3337388
2808: l_dunning_number NUMBER; --Bug 3337388
2809:

Line 3203: FROM PER_PEOPLE_F P,

3199: IF ( p_level_id IS NOT NULL )
3200: THEN
3201: OPEN p_employee_cursor FOR
3202: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3203: FROM PER_PEOPLE_F P,
3204: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3205: FROM PER_ALL_ASSIGNMENTS_F ASS,
3206: PER_PERIODS_OF_SERVICE B2
3207: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND

Line 3229: FROM PER_PEOPLE_F P,

3225: ELSE
3226:
3227: OPEN p_employee_cursor FOR
3228: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3229: FROM PER_PEOPLE_F P,
3230: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3231: FROM PER_ALL_ASSIGNMENTS_F ASS,
3232: PER_PERIODS_OF_SERVICE B2
3233: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND

Line 3486: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;

3482:
3483: l_employee_cursor EmployeeCursor;
3484: l_supervisor_id NUMBER;
3485:
3486: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
3487: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3488:
3489: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3490:

Line 3487: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

3483: l_employee_cursor EmployeeCursor;
3484: l_supervisor_id NUMBER;
3485:
3486: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
3487: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3488:
3489: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3490:
3491: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

Line 3489: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report

3485:
3486: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
3487: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3488:
3489: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3490:
3491: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3492: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3493:

Line 3491: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

3487: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3488:
3489: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3490:
3491: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3492: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3493:
3494: l_total_outstanding NUMBER;
3495: l_total_amt_outstanding NUMBER;

Line 3492: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

3488:
3489: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3490:
3491: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3492: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3493:
3494: l_total_outstanding NUMBER;
3495: l_total_amt_outstanding NUMBER;
3496: l_total_dispute NUMBER;

Line 3505: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE;

3501: l_gross_amount NUMBER := 0;
3502:
3503:
3504: l_final_manager_id NUMBER;
3505: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE;
3506:
3507: l_level NUMBER := 0;
3508: l_dunning_number NUMBER;
3509:

Line 3679: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

3675:
3676: l_employee_cursor EmployeeCursor;
3677: l_supervisor_id NUMBER;
3678:
3679: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3680:
3681: l_total_outstanding NUMBER;
3682: l_total_amt_outstanding NUMBER;
3683: l_total_dispute NUMBER;