APPS.IRC_UTILITIES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 615: ,per_all_assignments_f per_asg

611: --
612: cursor csr_has_vac is
613: select 1
614: from per_all_people_f per_per
615: ,per_all_assignments_f per_asg
616: ,per_vacancies per_vac
617: where per_per.party_id=p_party_id
618: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
619: and per_per.person_id=per_asg.person_id

Line 880: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;

876: l_object_version_number number;
877: l_return_status varchar2(30);
878: l_update_mode varchar2(30) := p_update_mode;
879: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
880: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
881: l_appln_tracking varchar2(1);
882: --
883: cursor c_assgn_details_row is
884: select *

Line 892: from per_all_assignments_f

888: and latest_details='Y';
889: --
890: cursor c_bg_id is
891: select business_group_id
892: from per_all_assignments_f
893: where assignment_id = p_assignment_id
894: and trunc(sysdate) between effective_start_date and effective_end_date;
895: --
896: cursor c_appln_tracking is

Line 990: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;

986: l_return_status varchar2(30);
987: l_update_mode varchar2(30);
988: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
989: l_appl_tracking varchar2(1);
990: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
991:
992: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;
993: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
994: cursor c_assgn_details is select 1 from irc_assignment_details_f where assignment_id =p_assignment_id and sysdate between effective_start_date and effective_end_Date and latest_details='Y';

Line 992: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;

988: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
989: l_appl_tracking varchar2(1);
990: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
991:
992: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;
993: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
994: cursor c_assgn_details is select 1 from irc_assignment_details_f where assignment_id =p_assignment_id and sysdate between effective_start_date and effective_end_Date and latest_details='Y';
995: cursor c_appln_tracking is select nvl(ORG_INFORMATION11,'N') from HR_ORGANIZATION_INFORMATION where organization_id=l_business_grp_id and org_information_context='BG Recruitment';
996: