APPS.GHR_FEHB_PLAN_DESIGN dependencies on BEN_PGM_F

Line 515: select * from ben_pgm_f

511: where transaction_category_id = p_transaction_category_id
512: and context_business_group_id = 0
513: and display_name = 'GHR_FEHB_SEED_PROGRAM_DESIGN';
514: Cursor update_program_status is
515: select * from ben_pgm_f
516: where name = 'Federal Employees Health Benefits'
517: and business_group_id = p_target_business_group_id;
518: --
519: Begin

Line 615: select 'Y' from ben_pgm_f

611: p_retcode OUT NOCOPY NUMBER,
612: p_target_business_group_id in Number) is
613:
614: Cursor check_pgm_exists is
615: select 'Y' from ben_pgm_f
616: where name = 'Federal Employees Health Benefits'
617: and business_group_id = p_target_business_group_id;
618:
619: l_proc varchar2(100):= 'Populate_fehb_plan_design.';