DBA Data[Home] [Help]

APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on FND_USER

Line 134: FROM fnd_user fu,

130: l_api_name VARCHAR2(30);
131:
132: CURSOR con_admin_name_csr IS
133: SELECT per.full_name
134: FROM fnd_user fu,
135: per_all_people_f per
136: WHERE fu.user_id = p_prev_con_admin_id
137: AND per.person_id = fu.employee_id;
138:

Line 544: CURSOR con_admin_name_csr (p_user_id IN fnd_user.user_id%TYPE) IS

540: AND (con_party.party_role_code = 'CUSTOMER_ORG' OR
541: con_party.party_role_code = 'PARTNER_ORG')
542: AND con_party.party_id = hz.party_id;
543:
544: CURSOR con_admin_name_csr (p_user_id IN fnd_user.user_id%TYPE) IS
545: SELECT nvl(per.full_name, fu.user_name)
546: FROM fnd_user fu,
547: per_all_people_f per
548: WHERE fu.user_id = p_user_id

Line 546: FROM fnd_user fu,

542: AND con_party.party_id = hz.party_id;
543:
544: CURSOR con_admin_name_csr (p_user_id IN fnd_user.user_id%TYPE) IS
545: SELECT nvl(per.full_name, fu.user_name)
546: FROM fnd_user fu,
547: per_all_people_f per
548: WHERE fu.user_id = p_user_id
549: AND per.person_id = fu.employee_id;
550:

Line 551: CURSOR validate_con_admin_csr (p_con_admin_id IN fnd_user.user_id%TYPE) IS

547: per_all_people_f per
548: WHERE fu.user_id = p_user_id
549: AND per.person_id = fu.employee_id;
550:
551: CURSOR validate_con_admin_csr (p_con_admin_id IN fnd_user.user_id%TYPE) IS
552: SELECT 1
553: FROM fnd_user fu,
554: per_all_people_f per
555: WHERE fu.user_id = p_con_admin_id

Line 553: FROM fnd_user fu,

549: AND per.person_id = fu.employee_id;
550:
551: CURSOR validate_con_admin_csr (p_con_admin_id IN fnd_user.user_id%TYPE) IS
552: SELECT 1
553: FROM fnd_user fu,
554: per_all_people_f per
555: WHERE fu.user_id = p_con_admin_id
556: AND per.person_id = fu.employee_id
557: AND sysdate between per.effective_start_date AND nvl(per.effective_end_date, sysdate);