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

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

1297: /**
1298: * Please refer to the package specifications for details
1299: */
1300:
1301: function GET_PHONE_NUMBER(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1302:
1303: l_phone_number per_phones.phone_number%type;
1304: cursor find_phone_number is
1305: select perph.phone_number

Line 1309: and perph.parent_table = 'PER_ALL_PEOPLE_F'

1305: select perph.phone_number
1306: from per_phones perph
1307: where perph.phone_type = 'W1'
1308: and perph.parent_id = p_person_id
1309: and perph.parent_table = 'PER_ALL_PEOPLE_F'
1310: and perph.date_from <= sysdate
1311: and nvl(perph.date_to, sysdate + 1) > sysdate;
1312:
1313:

Line 1329: l_person_id per_all_people_f.person_id%type;

1325: */
1326:
1327: function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number IS
1328: l_matches varchar2(5);
1329: l_person_id per_all_people_f.person_id%type;
1330: l_cursorid integer;
1331: l_blockstr varchar2(1000);
1332: l_dummy integer;
1333:

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

1365: /**
1366: * Please refer to the package specifications for details
1367: */
1368:
1369: function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1370:
1371: l_manager_name per_all_people_f.full_name%type;
1372: cursor find_mgr_name is
1373: select mgr.full_name

Line 1371: l_manager_name per_all_people_f.full_name%type;

1367: */
1368:
1369: function GET_MANAGER_NAME(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1370:
1371: l_manager_name per_all_people_f.full_name%type;
1372: cursor find_mgr_name is
1373: select mgr.full_name
1374: from per_all_assignments_f emp, per_all_people_f mgr
1375: where emp.supervisor_id = mgr.person_id

Line 1374: from per_all_assignments_f emp, per_all_people_f mgr

1370:
1371: l_manager_name per_all_people_f.full_name%type;
1372: cursor find_mgr_name is
1373: select mgr.full_name
1374: from per_all_assignments_f emp, per_all_people_f mgr
1375: where emp.supervisor_id = mgr.person_id
1376: and emp.person_id = p_person_id
1377: and emp.effective_start_date <= sysdate
1378: and nvl(emp.effective_end_date, sysdate + 1) > sysdate

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

1392: /**
1393: * Please refer to the package specifications for details
1394: */
1395:
1396: function GET_JOB_TITLE(p_person_id in per_all_people_f.person_id%type) return varchar2 IS
1397:
1398: l_title per_jobs_vl.name%type;
1399: cursor find_title is
1400: select name