APPS.HR_EX_EMPLOYEE_API dependencies on HR_PERSON_DEPLOYMENTS

Line 800: select * from hr_person_deployments where

796:
797: -- 2 cursors for GOLD bug 5465050
798:
799: cursor chk_pre_term_src_gold(p_src_bg_id number,p_gold_src_person_id number) is
800: select * from hr_person_deployments where
801: FROM_BUSINESS_GROUP_ID = p_src_bg_id and
802: FROM_PERSON_ID = p_gold_src_person_id;
803:
804: cursor chk_pre_term_dest_gold(p_dest_bg_id number,p_gold_dest_person_id number) is

Line 805: select * from hr_person_deployments where

801: FROM_BUSINESS_GROUP_ID = p_src_bg_id and
802: FROM_PERSON_ID = p_gold_src_person_id;
803:
804: cursor chk_pre_term_dest_gold(p_dest_bg_id number,p_gold_dest_person_id number) is
805: select * from hr_person_deployments where
806: TO_BUSINESS_GROUP_ID = p_dest_bg_id and
807: TO_PERSON_ID = p_gold_dest_person_id;
808:
809: --

Line 817: l_src_bg_rec hr_person_deployments%ROWTYPE;

813: l_ctc_status varchar2(30);*/
814:
815: -- 2 parameters for GOLD bug 5465050
816:
817: l_src_bg_rec hr_person_deployments%ROWTYPE;
818: l_dest_bg_rec hr_person_deployments%ROWTYPE;
819: --
820: --
821: --dparthas

Line 818: l_dest_bg_rec hr_person_deployments%ROWTYPE;

814:
815: -- 2 parameters for GOLD bug 5465050
816:
817: l_src_bg_rec hr_person_deployments%ROWTYPE;
818: l_dest_bg_rec hr_person_deployments%ROWTYPE;
819: --
820: --
821: --dparthas
822: CURSOR get_person_info IS