APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_ACTN_TYP

Line 6045: -- START OF BEN_ACTN_TYP ----------------------

6041: l_result_type_cd varchar2(30);
6042: l_information5 ben_copy_entity_results.information5%type;
6043: l_number_of_copies number(15);
6044: ---------------------------------------------------------------
6045: -- START OF BEN_ACTN_TYP ----------------------
6046: ---------------------------------------------------------------
6047: cursor c_eat(c_mirror_src_entity_result_id number ,
6048: c_table_alias varchar2) is
6049: select eat.*

Line 6050: from BEN_ACTN_TYP eat

6046: ---------------------------------------------------------------
6047: cursor c_eat(c_mirror_src_entity_result_id number ,
6048: c_table_alias varchar2) is
6049: select eat.*
6050: from BEN_ACTN_TYP eat
6051: where eat.business_group_id = p_business_group_id
6052: and not exists (
6053: select /* */ null
6054: from ben_copy_entity_results cpe

Line 6064: -- END OF BEN_ACTN_TYP ----------------------

6060: );
6061: l_actn_typ_id number(15);
6062: l_out_eat_result_id number(15);
6063: ---------------------------------------------------------------
6064: -- END OF BEN_ACTN_TYP ----------------------
6065: ---------------------------------------------------------------
6066: begin
6067: ---------------------------------------------------------------
6068: -- START OF BEN_ACTN_TYP ----------------------

Line 6068: -- START OF BEN_ACTN_TYP ----------------------

6064: -- END OF BEN_ACTN_TYP ----------------------
6065: ---------------------------------------------------------------
6066: begin
6067: ---------------------------------------------------------------
6068: -- START OF BEN_ACTN_TYP ----------------------
6069: ---------------------------------------------------------------
6070: --
6071: l_mirror_src_entity_result_id := null ; -- Hide in HGrid
6072: l_number_of_copies := p_number_of_copies;

Line 6151: -- END OF BEN_ACTN_TYP ----------------------

6147: end if;
6148: --
6149: end loop;
6150: ---------------------------------------------------------------
6151: -- END OF BEN_ACTN_TYP ----------------------
6152: ---------------------------------------------------------------
6153: end create_actn_typ_result ;
6154: ---------------------------------------------------------------
6155: -- START OF INTERSECTION NAME FUNCTIONS ----------------------

Line 6418: l_actn_typ_name ben_actn_typ.name%type := null;

6414: (
6415: p_actn_typ_id in number
6416: ) return varchar2 is
6417:
6418: l_actn_typ_name ben_actn_typ.name%type := null;
6419:
6420: cursor c_actn_typ_name is
6421: select eat.name
6422: from ben_actn_typ eat

Line 6422: from ben_actn_typ eat

6418: l_actn_typ_name ben_actn_typ.name%type := null;
6419:
6420: cursor c_actn_typ_name is
6421: select eat.name
6422: from ben_actn_typ eat
6423: where eat.actn_typ_id = p_actn_typ_id;
6424:
6425: begin
6426: open c_actn_typ_name;