eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELIGIBILITY_RULE_API dependencies on BEN_PTIP_F

Line 286: --updates elig_apls_flag to 'Y' in ben_ptip_f table.

282: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
283: and a.prtn_elig_id = b.prtn_elig_id
284: and a.plip_id = c.plip_id);
285: --
286: --updates elig_apls_flag to 'Y' in ben_ptip_f table.
287: update ben_ptip_f c
288: set c.elig_apls_flag = 'Y'
289: where exists
290: (select a.ptip_id

Line 287: update ben_ptip_f c

283: and a.prtn_elig_id = b.prtn_elig_id
284: and a.plip_id = c.plip_id);
285: --
286: --updates elig_apls_flag to 'Y' in ben_ptip_f table.
287: update ben_ptip_f c
288: set c.elig_apls_flag = 'Y'
289: where exists
290: (select a.ptip_id
291: from ben_prtn_elig_f a,

Line 796: --updates elig_apls_flag to 'N' in ben_ptip_f table

792: and c.plip_id = l_c1.plip_id;
793: --
794: elsif l_c1.ptip_id is not null then
795: --
796: --updates elig_apls_flag to 'N' in ben_ptip_f table
797: --only when no record found in profile and rule tables.
798: update ben_ptip_f c
799: set c.elig_apls_flag = 'N'
800: where not exists

Line 798: update ben_ptip_f c

794: elsif l_c1.ptip_id is not null then
795: --
796: --updates elig_apls_flag to 'N' in ben_ptip_f table
797: --only when no record found in profile and rule tables.
798: update ben_ptip_f c
799: set c.elig_apls_flag = 'N'
800: where not exists
801: (select a.ptip_id
802: from ben_prtn_elig_f a,