APPS.PQH_GSP_DEFAULT dependencies on BEN_PTNL_LER_FOR_PER

Line 37: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

33: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;
34: l_legislation_code per_business_groups.legislation_code%type;
35: l_return_status varchar2(1);
36:
37: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
38: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;
39:
40: cursor csr_ptnl_ler_dtls(cp_per_in_ler_id in number)
41: is

Line 38: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;

34: l_legislation_code per_business_groups.legislation_code%type;
35: l_return_status varchar2(1);
36:
37: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
38: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;
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

Line 44: ,ben_ptnl_ler_for_per ptnl

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:
48: cursor lesgislation_info is

Line 99: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

95: ,P_VOIDD_DT => l_voidd_dt
96: ,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
97: ,P_EFFECTIVE_DATE => P_Effective_Date);
98:
99: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
100: (p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
101: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
102: ,p_voidd_dt => p_effective_date
103: ,p_object_version_number => l_PTNL_LER_FOR_PER_OVN

Line 133: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

129: ,P_VOIDD_DT => l_voidd_dt
130: ,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
131: ,P_EFFECTIVE_DATE => P_Effective_Date);
132:
133: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
134: (p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
135: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
136: ,p_voidd_dt => p_effective_date
137: ,p_object_version_number => l_PTNL_LER_FOR_PER_OVN