APPS.PQH_GSP_DEFAULT dependencies on BEN_PER_IN_LER

Line 9: from ben_per_in_ler pil,per_all_assignments_f asg

5: l_assignment_id number;
6: begin
7: select asg.assignment_id
8: into l_assignment_id
9: from ben_per_in_ler pil,per_all_assignments_f asg
10: where p_effective_date between asg.effective_start_date and asg.effective_end_date
11: and pil.per_in_ler_id = p_per_in_ler_id
12: and pil.person_id = asg.person_id
13: and asg.assignment_type = 'E'

Line 43: from ben_per_in_ler per

39:
40: cursor csr_ptnl_ler_dtls(cp_per_in_ler_id in number)
41: is
42: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number
43: from ben_per_in_ler per
44: ,ben_ptnl_ler_for_per ptnl
45: where per.per_in_ler_id = cp_per_in_ler_id
46: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
47:

Line 50: from per_business_groups bg, ben_per_in_ler pil

46: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
47:
48: cursor lesgislation_info is
49: Select legislation_code
50: from per_business_groups bg, ben_per_in_ler pil
51: where pil.business_group_id = bg.business_group_id
52: and pil.per_in_ler_id = p_per_in_ler_id;
53: begin
54: -- This routine will be called by benmngle run to determine whether out of electable choice progressions

Line 87: L_PIL_OVN := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PER_IN_LER',

83: p_electbl_chc_id => p_electbl_chc_id,
84: p_return_code => p_return_code,
85: p_error_message => l_error_message);
86: if p_electbl_chc_id is null then
87: L_PIL_OVN := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PER_IN_LER',
88: p_key_column_name => 'PER_IN_LER_ID',
89: p_key_column_value => p_per_in_ler_id);
90: Ben_Person_Life_Event_api.UPDATE_PERSON_LIFE_EVENT
91: (P_PER_IN_LER_ID => P_PER_IN_LER_ID

Line 120: L_PIL_OVN := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PER_IN_LER',

116: ,p_message_type_cd => 'E'
117: ,p_message_text => Nvl(fnd_Message.Get,sqlerrm)
118: ,P_Effective_Date => P_Effective_Date);
119:
120: L_PIL_OVN := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PER_IN_LER',
121: p_key_column_name => 'PER_IN_LER_ID',
122: p_key_column_value => p_per_in_ler_id);
123:
124: Ben_Person_Life_Event_api.UPDATE_PERSON_LIFE_EVENT

Line 147: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

143: l_electbl_chc_id number;
144: begin
145: select epe.ELIG_PER_ELCTBL_CHC_ID
146: into l_electbl_chc_id
147: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
148: where pil.per_in_ler_id = epe.per_in_ler_id
149: and pil.per_in_ler_id = p_per_in_ler_id
150: and pil.per_in_ler_stat_cd = 'STRTD'
151: and epe.comp_lvl_cd ='OIPL'

Line 169: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

165: l_electbl_chc_id number;
166: begin
167: select epe.ELIG_PER_ELCTBL_CHC_ID
168: into l_electbl_chc_id
169: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
170: where pil.per_in_ler_id = epe.per_in_ler_id
171: and pil.per_in_ler_id = p_per_in_ler_id
172: and pil.per_in_ler_stat_cd = 'STRTD'
173: and epe.comp_lvl_cd ='PLAN'

Line 1207: Ben_Per_In_Ler Pler,

1203:
1204: Cursor Csr_Step is
1205: Select pqh_gsp_hr_to_stage.get_step_for_oipl(Elctbl.oipl_id, p_effective_date) Step_Id
1206: from Per_all_Assignments_F Asgt,
1207: Ben_Per_In_Ler Pler,
1208: Ben_Ler_F Ler,
1209: Ben_Elig_Per_Elctbl_Chc ELctbl,
1210: Ben_Enrt_Rt Rt
1211: Where Asgt.Assignment_Id = P_Assignment_id