APPS.BEN_SSPNDD_ENROLLMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 887: l_assignment_id per_all_assignments_f.assignment_id%type;

883: l_interim_enrt_bnft_id number;
884: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
885: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
886: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
887: l_assignment_id per_all_assignments_f.assignment_id%type;
888:
889: /********************* l_organization_id added by shdas **********/
890:
891: l_organization_id per_all_assignments_f.organization_id%type;

Line 891: l_organization_id per_all_assignments_f.organization_id%type;

887: l_assignment_id per_all_assignments_f.assignment_id%type;
888:
889: /********************* l_organization_id added by shdas **********/
890:
891: l_organization_id per_all_assignments_f.organization_id%type;
892: l_interim_action varchar2(30):='NT';
893: l_bnft_ordr_num number;
894: l_enrt_pl_id number := null;
895: l_enrt_chc_id number := null;

Line 910: from hr_locations_all loc,per_all_assignments_f asg

906: --
907:
908: Cursor c_state is
909: select region_2
910: from hr_locations_all loc,per_all_assignments_f asg
911: where loc.location_id = asg.location_id
912: and asg.person_id = p_person_id
913: and asg.assignment_type <> 'C'
914: and asg.primary_flag = 'Y'

Line 978: From per_all_assignments_f

974: ;
975:
976: Cursor c_paf is
977: Select assignment_id,organization_id
978: From per_all_assignments_f
979: Where person_id = p_person_id
980: and assignment_type <> 'C'
981: And business_group_id=p_business_group_id
982: and p_effective_date between