DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on FND_USER

Line 316: PROCEDURE get_default_routing_group(p_user_name IN fnd_user.user_name%TYPE

312: RAISE;
313: END get_personnel_system_indicator;
314: --
315:
316: PROCEDURE get_default_routing_group(p_user_name IN fnd_user.user_name%TYPE
317: ,p_routing_group_id IN OUT NOCOPY NUMBER
318: ,p_initiator_flag IN OUT NOCOPY VARCHAR2
319: ,p_requester_flag IN OUT NOCOPY VARCHAR2
320: ,p_authorizer_flag IN OUT NOCOPY VARCHAR2

Line 343: ,fnd_user use

339: ,pei.pei_information7 personnelist_flag
340: ,pei.pei_information8 approver_flag
341: ,pei.pei_information9 reviewer_flag
342: FROM per_people_extra_info pei
343: ,fnd_user use
344: WHERE use.user_name = p_user_name
345: AND pei.person_id = use.employee_id
346: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
347: AND pei.pei_information10 = 'Y';

Line 525: ,fnd_user usr

521: ,pei.pei_information7 personnelist_flag
522: ,pei.pei_information8 approver_flag
523: ,pei.pei_information9 reviewer_flag
524: from per_people_extra_info pei
525: ,fnd_user usr
526: where usr.user_name = l_user_name
527: and pei.person_id = usr.employee_id
528: and pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
529: and pei.pei_information3 = p_routing_group_id;

Line 1306: FROM fnd_user use

1302: l_ret_val NUMBER(9) := NULL;
1303: --
1304: CURSOR c_use IS
1305: SELECT use.employee_id
1306: FROM fnd_user use
1307: WHERE use.user_name = p_user_name;
1308:
1309: BEGIN
1310: FOR c_use_rec IN c_use LOOP