APPS.PA_CI_ACTIONS_UTIL dependencies on FND_USER

Line 61: select person_party_id from fnd_user

57: return number
58: IS
59: -- Bug 4527617: Modified Cursor Definition.
60: Cursor external is
61: select person_party_id from fnd_user
62: where user_id = p_user_id;
63: /* Cursor external is
64: select customer_id from fnd_user
65: where user_id = p_user_id; */

Line 64: select customer_id from fnd_user

60: Cursor external is
61: select person_party_id from fnd_user
62: where user_id = p_user_id;
63: /* Cursor external is
64: select customer_id from fnd_user
65: where user_id = p_user_id; */
66:
67:
68: -- Modified the cursor definiton for bug#4068669.

Line 72: fnd_user fu

68: -- Modified the cursor definiton for bug#4068669.
69: Cursor internal is
70: select pap.party_id
71: from per_all_people_f pap,
72: fnd_user fu
73: where fu.user_id = p_user_id
74: and fu.employee_id = pap.person_id
75: and trunc(sysdate) between trunc(pap.effective_start_date) and trunc(pap.effective_end_date) ;
76: /*select h.party_id

Line 78: ,fnd_user f

74: and fu.employee_id = pap.person_id
75: and trunc(sysdate) between trunc(pap.effective_start_date) and trunc(pap.effective_end_date) ;
76: /*select h.party_id
77: from hz_parties h
78: ,fnd_user f
79: where h.orig_system_reference = CONCAT('PER:',f.employee_id)
80: and f.user_id = p_user_id;*/
81:
82: l_party_id number;