APPS.GHR_TSP_CATCHUP_PLAN_DESIGN dependencies on BEN_PGM_F

Line 35: select * from ben_pgm_f

31: where transaction_category_id = p_transaction_category_id
32: and context_business_group_id = 0
33: and display_name = 'GHR_TSP_CATCHUP_SEED_PROGRAM_DESIGN';
34: Cursor update_program_status is
35: select * from ben_pgm_f
36: where name = 'Federal Thrift Savings Plan (TSP) Catch Up Contributions'
37: and business_group_id = p_target_business_group_id;
38: --
39: Begin

Line 121: select 'Y' tsp_exists from ben_pgm_f

117: p_retcode OUT NOCOPY NUMBER,
118: p_target_business_group_id in Number) is
119:
120: Cursor c_check_pgm_tsp_exists is
121: select 'Y' tsp_exists from ben_pgm_f
122: where name = 'Federal Thrift Savings Plan (TSP)'
123: and business_group_id = p_target_business_group_id
124: and pgm_stat_cd = 'A';
125:

Line 127: select 'Y' from ben_pgm_f

123: and business_group_id = p_target_business_group_id
124: and pgm_stat_cd = 'A';
125:
126: Cursor check_pgm_exists is
127: select 'Y' from ben_pgm_f
128: where name = 'Federal Thrift Savings Plan (TSP) Catch Up Contributions'
129: and business_group_id = p_target_business_group_id;
130:
131: l_proc varchar2(100):= substr(g_package||'Populate_tspc_plan_design',1,30);