DBA Data[Home] [Help]

APPS.GHR_WF_PKG dependencies on FND_USER

Line 1375: ,fnd_user use

1371: ,pei.pei_information8 approver_flag
1372: ,pei.pei_information9 reviewer_flag
1373: ,pei.person_id person_id
1374: FROM per_people_extra_info pei
1375: ,fnd_user use
1376: WHERE use.user_name = p_user_name
1377: AND pei.person_id = use.employee_id
1378: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
1379: AND pei.pei_information3 = ( SELECT routing_group_id from

Line 1390: fnd_user usr

1386: per.first_name,
1387: per.last_name,
1388: per.middle_names
1389: from per_people_f per,
1390: fnd_user usr
1391: where upper(usr.user_name) = upper(p_user_name)
1392: and per.person_id = usr.employee_id
1393: and l_effective_date
1394: between effective_start_date

Line 1403: fnd_user usr

1399: per.first_name,
1400: per.last_name,
1401: per.middle_names
1402: FROM per_people_f per,
1403: fnd_user usr
1404: WHERE usr.user_name = upper(p_user_name)
1405: AND per.person_id = usr.employee_id
1406: AND l_effective_date
1407: BETWEEN effective_start_date

Line 1437: l_current_user_name fnd_user.user_name%type;

1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;
1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1439: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1440:
1441: l_result varchar2(4000);