APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PGM_F

Line 68: -- START OF BEN_PGM_F ----------------------

64: -- Bug : 3752407
65: --
66:
67: ---------------------------------------------------------------
68: -- START OF BEN_PGM_F ----------------------
69: ---------------------------------------------------------------
70:
71: cursor c_pgm_from_parent(c_PGM_ID number) is
72: select distinct pgm_id

Line 73: from BEN_PGM_F

69: ---------------------------------------------------------------
70:
71: cursor c_pgm_from_parent(c_PGM_ID number) is
72: select distinct pgm_id
73: from BEN_PGM_F
74: where PGM_ID = c_PGM_ID ;
75:
76: --
77: cursor c_pgm(c_pgm_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is

Line 79: from BEN_PGM_F pgm

75:
76: --
77: cursor c_pgm(c_pgm_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
78: select pgm.*
79: from BEN_PGM_F pgm
80: where pgm.pgm_id = c_pgm_id
81: --and pgm.business_group_id = p_business_group_id
82: and not exists (
83: select /* */ null

Line 97: -- END OF BEN_PGM_F ----------------------

93: and information3 = pgm.effective_end_date
94: );
95: l_out_pgm_result_id number(15);
96: ---------------------------------------------------------------
97: -- END OF BEN_PGM_F ----------------------
98: ---------------------------------------------------------------
99: ---------------------------------------------------------------
100: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
101: ---------------------------------------------------------------

Line 915: -- START OF BEN_PGM_F ----------------------

911: end if;
912:
913: --
914: ---------------------------------------------------------------
915: -- START OF BEN_PGM_F ----------------------
916: ---------------------------------------------------------------
917: l_mirror_src_entity_result_id := null ;
918: --
919: for l_pgm_rec in c_pgm(p_pgm_id,l_mirror_src_entity_result_id,'PGM' ) loop

Line 1343: -- END OF BEN_PGM_F ----------------------

1339: end if;
1340:
1341: end loop;
1342: ---------------------------------------------------------------
1343: -- END OF BEN_PGM_F ----------------------
1344: ---------------------------------------------------------------
1345: --
1346:
1347: if p_number_of_copies = 1 then

Line 6187: l_pgm_name ben_pgm_f.name%type := null;

6183: p_pgm_id in number
6184: ,p_effective_date in date
6185: ) return varchar2 is
6186:
6187: l_pgm_name ben_pgm_f.name%type := null;
6188:
6189: cursor c_pgm_name is
6190: select pgm.name
6191: from ben_pgm_f pgm

Line 6191: from ben_pgm_f pgm

6187: l_pgm_name ben_pgm_f.name%type := null;
6188:
6189: cursor c_pgm_name is
6190: select pgm.name
6191: from ben_pgm_f pgm
6192: where pgm.pgm_id = p_pgm_id
6193: and p_effective_date between pgm.effective_start_date
6194: and pgm.effective_end_date;
6195:

Line 6266: l_pgm_id ben_pgm_f.pgm_id%type;

6262: where ctp.ptip_id = p_ptip_id
6263: and p_effective_date between ctp.effective_start_date
6264: and ctp.effective_end_date;
6265:
6266: l_pgm_id ben_pgm_f.pgm_id%type;
6267: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
6268: l_ptip_name varchar2(500);
6269:
6270: begin

Line 6296: l_pgm_id ben_pgm_f.pgm_id%type;

6292: where cpp.plip_id = p_plip_id
6293: and p_effective_date between cpp.effective_start_date
6294: and cpp.effective_end_date;
6295:
6296: l_pgm_id ben_pgm_f.pgm_id%type;
6297: l_pl_id ben_pl_f.pl_id%type;
6298: l_plip_name varchar2(500);
6299:
6300: begin