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.AR_CMGT_UTIL dependencies on PER_ALL_PEOPLE_F

Line 376: PER_ALL_PEOPLE_F per

372: SELECT per.FULL_NAME
373: FROM JTF_RS_RESOURCE_EXTNS rextns,
374: JTF_RS_ROLE_RELATIONS rel,
375: JTF_RS_ROLES_VL role_vl,
376: PER_ALL_PEOPLE_F per
377: WHERE role_vl.role_type_code = 'CREDIT_MGMT'
378: and role_vl.role_code = 'CREDIT_ANALYST'
379: and role_vl.role_id = rel.role_id
380: and rel.role_resource_type = 'RS_INDIVIDUAL'

Line 1310: l_requestor_name per_all_people_f.full_name%TYPE;

1306:
1307: FUNCTION get_requestor_name(p_requestor_id IN NUMBER)
1308: RETURN VARCHAR2 IS
1309:
1310: l_requestor_name per_all_people_f.full_name%TYPE;
1311:
1312: CURSOR crequestorName IS
1313: SELECT FULL_NAME
1314: FROM PER_ALL_PEOPLE_F

Line 1314: FROM PER_ALL_PEOPLE_F

1310: l_requestor_name per_all_people_f.full_name%TYPE;
1311:
1312: CURSOR crequestorName IS
1313: SELECT FULL_NAME
1314: FROM PER_ALL_PEOPLE_F
1315: WHERE sysdate between effective_start_date and effective_end_date
1316: and person_id = p_requestor_id;
1317:
1318: BEGIN