APPS.BEN_ELIGIBILITY_RULE_API dependencies on BEN_OIPL_F

Line 308: --updates elig_apls_flag to 'Y' in ben_oipl_f table.

304: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
305: and a.prtn_elig_id = b.prtn_elig_id
306: and a.pl_id = c.pl_id);
307: --
308: --updates elig_apls_flag to 'Y' in ben_oipl_f table.
309: update ben_oipl_f c
310: set c.elig_apls_flag = 'Y'
311: where exists
312: (select a.oipl_id

Line 309: update ben_oipl_f c

305: and a.prtn_elig_id = b.prtn_elig_id
306: and a.pl_id = c.pl_id);
307: --
308: --updates elig_apls_flag to 'Y' in ben_oipl_f table.
309: update ben_oipl_f c
310: set c.elig_apls_flag = 'Y'
311: where exists
312: (select a.oipl_id
313: from ben_prtn_elig_f a,

Line 836: --updates elig_apls_flag to 'N' in ben_oipl_f table

832: and c.pl_id = l_c1.pl_id;
833: --
834: elsif l_c1.oipl_id is not null then
835: --
836: --updates elig_apls_flag to 'N' in ben_oipl_f table
837: --only when no record found in profile and rule tables.
838: update ben_oipl_f c
839: set c.elig_apls_flag = 'N'
840: where not exists

Line 838: update ben_oipl_f c

834: elsif l_c1.oipl_id is not null then
835: --
836: --updates elig_apls_flag to 'N' in ben_oipl_f table
837: --only when no record found in profile and rule tables.
838: update ben_oipl_f c
839: set c.elig_apls_flag = 'N'
840: where not exists
841: (select a.oipl_id
842: from ben_prtn_elig_f a,