APPS.BEN_RELATED_PERSON_LER_API dependencies on BEN_PTNL_LER_FOR_PER

Line 30: from ben_ptnl_ler_for_per

26: cursor le_exists(p_person_id in number
27: ,p_ler_id in number
28: ,p_lf_evt_ocrd_dt in date) is
29: select 'Y'
30: from ben_ptnl_ler_for_per
31: where person_id = p_person_id
32: and ler_id = p_ler_id
33: /* commenting for bug 5968595
34: and PTNL_LER_FOR_PER_STAT_CD <> 'VOIDD' /* Bug : 4624390 */

Line 40: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

36: --
37: --
38: -- output variables from API call.
39: --
40: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
41: l_object_version_number ben_ptnl_ler_for_per.object_version_number%type;
42: --
43: l_mnl_dt date;
44: l_dtctd_dt date;

Line 41: l_object_version_number ben_ptnl_ler_for_per.object_version_number%type;

37: --
38: -- output variables from API call.
39: --
40: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
41: l_object_version_number ben_ptnl_ler_for_per.object_version_number%type;
42: --
43: l_mnl_dt date;
44: l_dtctd_dt date;
45: l_procd_dt date;

Line 108: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

104: -- type exists do nothing.
105: --
106: if le_exists%notfound then
107: close le_exists;
108: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
109: (p_validate => false,
110: p_effective_date => p_effective_date,
111: p_business_group_id => p_business_group_id,
112: p_person_id => l_con_rec(l_count).contact_person_id,