APPS.HR_EX_EMPLOYEE_API dependencies on HR_PERSON_DEPLOYMENTS

Line 740: select * from hr_person_deployments where

736:
737: -- 2 cursors for GOLD bug 5465050
738:
739: cursor chk_pre_term_src_gold(p_src_bg_id number,p_gold_src_person_id number) is
740: select * from hr_person_deployments where
741: FROM_BUSINESS_GROUP_ID = p_src_bg_id and
742: FROM_PERSON_ID = p_gold_src_person_id;
743:
744: cursor chk_pre_term_dest_gold(p_dest_bg_id number,p_gold_dest_person_id number) is

Line 745: select * from hr_person_deployments where

741: FROM_BUSINESS_GROUP_ID = p_src_bg_id and
742: FROM_PERSON_ID = p_gold_src_person_id;
743:
744: cursor chk_pre_term_dest_gold(p_dest_bg_id number,p_gold_dest_person_id number) is
745: select * from hr_person_deployments where
746: TO_BUSINESS_GROUP_ID = p_dest_bg_id and
747: TO_PERSON_ID = p_gold_dest_person_id;
748:
749: --

Line 757: l_src_bg_rec hr_person_deployments%ROWTYPE;

753: l_ctc_status varchar2(30);*/
754:
755: -- 2 parameters for GOLD bug 5465050
756:
757: l_src_bg_rec hr_person_deployments%ROWTYPE;
758: l_dest_bg_rec hr_person_deployments%ROWTYPE;
759: --
760: --
761:

Line 758: l_dest_bg_rec hr_person_deployments%ROWTYPE;

754:
755: -- 2 parameters for GOLD bug 5465050
756:
757: l_src_bg_rec hr_person_deployments%ROWTYPE;
758: l_dest_bg_rec hr_person_deployments%ROWTYPE;
759: --
760: --
761:
762: --