APPS.OZF_APPROVAL_PVT dependencies on FND_USER

Line 129: fnd_user usr

125: from jtf_auth_principal_maps jtfpm,
126: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
127: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
128: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
129: fnd_user usr
130: where PJ.user_name = jtfp1.principal_name
131: and pj.category = 'EMPLOYEE'
132: and usr.user_id = pj.user_id
133: and (usr.end_date > sysdate OR usr.end_date IS NULL)

Line 314: user_id fnd_user.user_id%type,

310:
311: -- Update AME with approvers action
312: /*
313: type approverRecord is record(
314: user_id fnd_user.user_id%type,
315: person_id per_all_people_f.person_id%type,
316: first_name per_all_people_f.first_name%type,
317: last_name per_all_people_f.last_name%type,
318: api_insertion varchar2(1),

Line 1267: SELECT fnd_user.user_name

1263:
1264:
1265:
1266: CURSOR csr_cm (p_partner_id number) IS
1267: SELECT fnd_user.user_name
1268: FROM pv_partner_accesses acc
1269: , jtf_rs_resource_extns res
1270: , fnd_user
1271: WHERE acc.partner_id = p_partner_id

Line 1270: , fnd_user

1266: CURSOR csr_cm (p_partner_id number) IS
1267: SELECT fnd_user.user_name
1268: FROM pv_partner_accesses acc
1269: , jtf_rs_resource_extns res
1270: , fnd_user
1271: WHERE acc.partner_id = p_partner_id
1272: AND acc.resource_id = res.resource_id
1273: AND res.user_id = fnd_user.user_id;
1274:

Line 1273: AND res.user_id = fnd_user.user_id;

1269: , jtf_rs_resource_extns res
1270: , fnd_user
1271: WHERE acc.partner_id = p_partner_id
1272: AND acc.resource_id = res.resource_id
1273: AND res.user_id = fnd_user.user_id;
1274:
1275:
1276: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1277: SELECT fu.user_name

Line 1279: , fnd_user fu

1275:
1276: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1277: SELECT fu.user_name
1278: FROM ozf_approval_access oaa
1279: , fnd_user fu
1280: --, jtf_rs_resource_extns jre
1281: WHERE oaa.object_type = p_object_type
1282: AND oaa.object_id = p_object_id
1283: AND oaa.approver_type = 'USER'

Line 2088: -- IF approver has been defined as FND USER in AME Setup

2084: IF l_approvers_tbl.count <> 0 THEN
2085: FOR i IN 1 .. l_approvers_tbl.count LOOP
2086: l_orig_system_id := l_approvers_tbl(i).orig_system_id;
2087: l_orig_system := l_approvers_tbl(i).orig_system;
2088: -- IF approver has been defined as FND USER in AME Setup
2089: -- TDD Assumption: Only a valid resource shall be considered as an approver
2090: IF (l_orig_system = 'FND_USR') THEN
2091: l_user_id := l_orig_system_id;
2092: OPEN csr_user_info(l_user_id);

Line 2977: fnd_user fu

2973:
2974: CURSOR csr_approvers (p_object_id IN NUMBER) IS
2975: SELECT fu.user_name
2976: FROM ozf_sd_request_access ora,
2977: fnd_user fu
2978: WHERE ora.request_header_id = p_object_id
2979: AND ora.person_id IS NULL
2980: AND ora.user_id = fu.user_id
2981: AND ora.approver_flag = 'Y'

Line 2997: fnd_user fu

2993:
2994: CURSOR csr_access_members(p_object_id IN NUMBER) IS
2995: SELECT fu.user_name
2996: FROM ozf_sd_request_access ora,
2997: fnd_user fu
2998: WHERE ora.request_header_id = p_object_id
2999: AND ora.person_id IS NULL
3000: AND ora.user_id = fu.user_id
3001: AND ora.enabled_flag = 'Y'