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.

[Home] [Help]

APPS.UMX_REGISTRATION_PVT dependencies on PER_ALL_PEOPLE_F

Line 1316: function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2 IS

1312: /**
1313: * Please refer to the package specifications for details
1314: */
1315:
1316: function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1317:
1318: l_phone_number per_phones.phone_number%type;
1319: cursor find_phone_number is
1320: select perph.phone_number

Line 1324: and perph.parent_table = 'PER_ALL_PEOPLE_F'

1320: select perph.phone_number
1321: from per_phones perph
1322: where perph.phone_type = 'W1'
1323: and perph.parent_id = p_person_id
1324: and perph.parent_table = 'PER_ALL_PEOPLE_F'
1325: and perph.date_from <= sysdate
1326: and nvl(perph.date_to, sysdate + 1) > sysdate;
1327:
1328:

Line 1344: l_person_id per_all_people_f.person_id%type;

1340: */
1341:
1342: function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number IS
1343: l_matches varchar2(5);
1344: l_person_id per_all_people_f.person_id%type;
1345: l_cursorid integer;
1346: l_blockstr varchar2(1000);
1347: l_dummy integer;
1348:

Line 1384: function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2 IS

1380: /**
1381: * Please refer to the package specifications for details
1382: */
1383:
1384: function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1385:
1386: l_manager_name per_all_people_f.full_name%type;
1387: cursor find_mgr_name is
1388: select mgr.full_name

Line 1386: l_manager_name per_all_people_f.full_name%type;

1382: */
1383:
1384: function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1385:
1386: l_manager_name per_all_people_f.full_name%type;
1387: cursor find_mgr_name is
1388: select mgr.full_name
1389: from per_all_assignments_f emp, per_all_people_f mgr
1390: where emp.supervisor_id = mgr.person_id

Line 1389: from per_all_assignments_f emp, per_all_people_f mgr

1385:
1386: l_manager_name per_all_people_f.full_name%type;
1387: cursor find_mgr_name is
1388: select mgr.full_name
1389: from per_all_assignments_f emp, per_all_people_f mgr
1390: where emp.supervisor_id = mgr.person_id
1391: and emp.person_id = p_person_id
1392: and emp.effective_start_date <= sysdate
1393: and nvl(emp.effective_end_date, sysdate + 1) > sysdate

Line 1411: function GET_JOB_TITLE(p_person_id in per_all_people_f.person_id%type) return varchar2 IS

1407: /**
1408: * Please refer to the package specifications for details
1409: */
1410:
1411: function GET_JOB_TITLE(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1412:
1413: l_title per_jobs_vl.name%type;
1414: cursor find_title is
1415: select name