APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_ACTN_TYP

Line 6044: -- START OF BEN_ACTN_TYP ----------------------

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

Line 6049: from BEN_ACTN_TYP eat

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

Line 6063: -- END OF BEN_ACTN_TYP ----------------------

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

Line 6067: -- START OF BEN_ACTN_TYP ----------------------

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

Line 6150: -- END OF BEN_ACTN_TYP ----------------------

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

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

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

Line 6421: from ben_actn_typ eat

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