APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on PER_ALL_PEOPLE_F

Line 135: per_all_people_f per

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:
139: CURSOR doc_type_name_csr IS

Line 186: l_con_admin_name per_all_people_f.full_name%TYPE;

182: l_ou_name hr_all_organization_units.name%TYPE;
183: l_salesperson_name jtf_rs_salesreps.name%TYPE;
184: l_trans_type_name oe_transaction_types_tl.name%TYPE;
185: l_sales_grp_name jtf_rs_groups_tl.group_name%TYPE;
186: l_con_admin_name per_all_people_f.full_name%TYPE;
187: l_not_available_text fnd_new_messages.message_text%TYPE;
188:
189: BEGIN
190:

Line 547: per_all_people_f per

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:
551: CURSOR validate_con_admin_csr (p_con_admin_id IN fnd_user.user_id%TYPE) IS

Line 554: per_all_people_f per

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);
558:

Line 580: l_new_con_admin_user_name per_all_people_f.full_name%TYPE;

576: l_selected_doc_types OKC_TERMS_UTIL_PVT.doc_types_tbl;
577: l_new_con_admin_user_ids OKC_TERMS_UTIL_PVT.new_con_admin_user_ids_tbl;
578: l_doc_index NUMBER(4) := 0;
579: l_new_con_admin_user_id okc_template_usages.contract_admin_id%TYPE;
580: l_new_con_admin_user_name per_all_people_f.full_name%TYPE;
581:
582: l_batch_size number(4) := 1000;
583: l_cust_names varchar2(4000);
584:

Line 598: l_current_con_admin_name per_all_people_f.full_name%TYPE;

594: l_msg_code VARCHAR2(2000);
595: l_msg_type VARCHAR2(1);
596: l_temp NUMBER;
597: l_rec_index NUMBER;
598: l_current_con_admin_name per_all_people_f.full_name%TYPE;
599:
600: BEGIN
601:
602: l_api_name := 'update_con_admin_manager';