APPS.BEN_SSPNDD_ENROLLMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 942: l_assignment_id per_all_assignments_f.assignment_id%type;

938: l_interim_enrt_bnft_id number;
939: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
940: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
941: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
942: l_assignment_id per_all_assignments_f.assignment_id%type;
943:
944: /********************* l_organization_id added by shdas **********/
945:
946: l_organization_id per_all_assignments_f.organization_id%type;

Line 946: l_organization_id per_all_assignments_f.organization_id%type;

942: l_assignment_id per_all_assignments_f.assignment_id%type;
943:
944: /********************* l_organization_id added by shdas **********/
945:
946: l_organization_id per_all_assignments_f.organization_id%type;
947: l_interim_action varchar2(30):='NT';
948: l_bnft_ordr_num number;
949: l_enrt_pl_id number := null;
950: l_enrt_chc_id number := null;

Line 966: from hr_locations_all loc,per_all_assignments_f asg

962: --
963:
964: Cursor c_state is
965: select region_2
966: from hr_locations_all loc,per_all_assignments_f asg
967: where loc.location_id = asg.location_id
968: and asg.person_id = p_person_id
969: and asg.assignment_type <> 'C'
970: and asg.primary_flag = 'Y'

Line 1034: From per_all_assignments_f

1030: ;
1031:
1032: Cursor c_paf is
1033: Select assignment_id,organization_id
1034: From per_all_assignments_f
1035: Where person_id = p_person_id
1036: and assignment_type <> 'C'
1037: And business_group_id=p_business_group_id
1038: and p_effective_date between