APPS.BEN_DETERMINE_ELIGIBILITY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 19: ,p_empasgast_row in out NOCOPY per_assignment_status_types%rowtype

15: ,p_per_row in out NOCOPY per_all_people_f%rowtype
16: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
17: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
18: ,p_appasg_row in out NOCOPY ben_person_object.g_cache_ass_table
19: ,p_empasgast_row in out NOCOPY per_assignment_status_types%rowtype
20: ,p_benasgast_row in out NOCOPY per_assignment_status_types%rowtype
21: ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype
22: ,p_person_id in number
23: ,p_business_group_id in number

Line 20: ,p_benasgast_row in out NOCOPY per_assignment_status_types%rowtype

16: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
17: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
18: ,p_appasg_row in out NOCOPY ben_person_object.g_cache_ass_table
19: ,p_empasgast_row in out NOCOPY per_assignment_status_types%rowtype
20: ,p_benasgast_row in out NOCOPY per_assignment_status_types%rowtype
21: ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype
22: ,p_person_id in number
23: ,p_business_group_id in number
24: ,p_effective_date in date

Line 79: l_terminated per_assignment_status_types.per_system_status%type;

75: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
76: l_dpnt_pl_id ben_pl_f.pl_id%type;
77: l_exists varchar2(30);
78: --
79: l_terminated per_assignment_status_types.per_system_status%type;
80: l_assignment_id per_all_assignments_f.assignment_id%type;
81: l_found_profile varchar2(1) := 'N';
82: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
83: l_pl_rec ben_cobj_cache.g_pl_inst_row;

Line 193: l_ast_rec per_assignment_status_types%rowtype;

189: --
190: -- bug 2424041 ends
191: --
192: l_typ_rec ben_person_object.g_cache_typ_table;
193: l_ast_rec per_assignment_status_types%rowtype;
194: l_appass_rec ben_person_object.g_cache_ass_table;
195: --
196: cursor c_ff_use_asg(cv_formula_id in number) is
197: select 'Y'