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 2460: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

2456:
2457: l_employee_cursor EmployeeCursor;
2458: l_supervisor_id NUMBER;
2459:
2460: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2461:
2462: l_total_outstanding NUMBER;
2463: l_total_amt_outstanding NUMBER;
2464: l_total_dispute NUMBER;

Line 2711: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;

2707:
2708: l_employee_cursor EmployeeCursor;
2709: l_supervisor_id NUMBER;
2710:
2711: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
2712: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2713:
2714: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2715: l_count NUMBER := 0; --Direct Report

Line 2712: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

2708: l_employee_cursor EmployeeCursor;
2709: l_supervisor_id NUMBER;
2710:
2711: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
2712: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2713:
2714: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2715: l_count NUMBER := 0; --Direct Report
2716:

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

2710:
2711: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
2712: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2713:
2714: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2715: l_count NUMBER := 0; --Direct Report
2716:
2717: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2718: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

Line 2717: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

2713:
2714: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2715: l_count NUMBER := 0; --Direct Report
2716:
2717: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2718: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2719:
2720: l_total_outstanding NUMBER;
2721: l_total_amt_outstanding NUMBER;

Line 2718: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

2714: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
2715: l_count NUMBER := 0; --Direct Report
2716:
2717: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
2718: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
2719:
2720: l_total_outstanding NUMBER;
2721: l_total_amt_outstanding NUMBER;
2722: l_total_dispute NUMBER;

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

2727: l_gross_amount NUMBER := 0;
2728:
2729:
2730: l_final_manager_id NUMBER; --bug 3337443
2731: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE; --Bug 3337443
2732:
2733: l_level NUMBER := 0; --Bug 3337388
2734: l_dunning_number NUMBER; --Bug 3337388
2735:

Line 3130: FROM PER_PEOPLE_F P,

3126: IF ( p_level_id IS NOT NULL )
3127: THEN
3128: OPEN p_employee_cursor FOR
3129: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3130: FROM PER_PEOPLE_F P,
3131: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3132: FROM PER_ALL_ASSIGNMENTS_F ASS,
3133: PER_PERIODS_OF_SERVICE B2
3134: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND

Line 3156: FROM PER_PEOPLE_F P,

3152: ELSE
3153:
3154: OPEN p_employee_cursor FOR
3155: SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
3156: FROM PER_PEOPLE_F P,
3157: ( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
3158: FROM PER_ALL_ASSIGNMENTS_F ASS,
3159: PER_PERIODS_OF_SERVICE B2
3160: WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND

Line 3413: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;

3409:
3410: l_employee_cursor EmployeeCursor;
3411: l_supervisor_id NUMBER;
3412:
3413: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
3414: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3415:
3416: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3417:

Line 3414: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

3410: l_employee_cursor EmployeeCursor;
3411: l_supervisor_id NUMBER;
3412:
3413: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
3414: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3415:
3416: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3417:
3418: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

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

3412:
3413: l_supervisor_name PER_PEOPLE_F.FULL_NAME%TYPE;
3414: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3415:
3416: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3417:
3418: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3419: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3420:

Line 3418: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

3414: l_supervisor_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3415:
3416: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3417:
3418: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3419: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3420:
3421: l_total_outstanding NUMBER;
3422: l_total_amt_outstanding NUMBER;

Line 3419: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;

3415:
3416: l_direct_manager_name PER_PEOPLE_F.FULL_NAME%TYPE; --Direct Report
3417:
3418: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3419: l_employee_display_name PER_PEOPLE_F.FULL_NAME%TYPE;
3420:
3421: l_total_outstanding NUMBER;
3422: l_total_amt_outstanding NUMBER;
3423: l_total_dispute NUMBER;

Line 3432: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE;

3428: l_gross_amount NUMBER := 0;
3429:
3430:
3431: l_final_manager_id NUMBER;
3432: l_direct_report_name PER_PEOPLE_F.FULL_NAME%TYPE;
3433:
3434: l_level NUMBER := 0;
3435: l_dunning_number NUMBER;
3436:

Line 3610: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;

3606:
3607: l_employee_cursor EmployeeCursor;
3608: l_supervisor_id NUMBER;
3609:
3610: l_employee_name PER_PEOPLE_F.FULL_NAME%TYPE;
3611:
3612: l_total_outstanding NUMBER;
3613: l_total_amt_outstanding NUMBER;
3614: l_total_dispute NUMBER;