APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACRS_PTIP_CVG_F

Line 16735: -- START OF BEN_ACRS_PTIP_CVG_F----------------------

16731: l_result_type_cd varchar2(30);
16732: l_information5 ben_copy_entity_results.information5%type;
16733: l_number_of_copies number(15);
16734: ---------------------------------------------------------------
16735: -- START OF BEN_ACRS_PTIP_CVG_F----------------------
16736: ---------------------------------------------------------------
16737:
16738: cursor c_apc_from_parent(c_PGM_ID number) is
16739: select DISTINCT acrs_ptip_cvg_id

Line 16740: from BEN_ACRS_PTIP_CVG_F

16736: ---------------------------------------------------------------
16737:
16738: cursor c_apc_from_parent(c_PGM_ID number) is
16739: select DISTINCT acrs_ptip_cvg_id
16740: from BEN_ACRS_PTIP_CVG_F
16741: where PGM_ID = c_PGM_ID;
16742:
16743: cursor c_apc(c_acrs_ptip_cvg_id number,c_mirror_src_entity_result_id number,
16744: c_table_alias varchar2 ) is

Line 16746: from BEN_ACRS_PTIP_CVG_F apc

16742:
16743: cursor c_apc(c_acrs_ptip_cvg_id number,c_mirror_src_entity_result_id number,
16744: c_table_alias varchar2 ) is
16745: select apc.*
16746: from BEN_ACRS_PTIP_CVG_F apc
16747: where apc.acrs_ptip_cvg_id = c_acrs_ptip_cvg_id
16748: --and apc.business_group_id = p_business_group_id
16749: and not exists (
16750: select /* */ null

Line 16757: -- and trt.where_clause = 'BEN_ACRS_PTIP_CVG_F'

16753: where copy_entity_txn_id = p_copy_entity_txn_id
16754: -- and trt.table_route_id = cpe.table_route_id
16755: and ( -- c_mirror_src_entity_result_id is null or
16756: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16757: -- and trt.where_clause = 'BEN_ACRS_PTIP_CVG_F'
16758: and cpe.table_alias = c_table_alias
16759: and information1 = c_acrs_ptip_cvg_id
16760: -- and information4 = apc.business_group_id
16761: );

Line 16765: -- END OF BEN_ACRS_PTIP_CVG_F----------------------

16761: );
16762: l_acrs_ptip_cvg_id number(15);
16763: l_out_apc_result_id number(15);
16764: ---------------------------------------------------------------
16765: -- END OF BEN_ACRS_PTIP_CVG_F----------------------
16766: ---------------------------------------------------------------
16767: begin
16768: l_number_of_copies := p_number_of_copies ;
16769: ---------------------------------------------------------------

Line 16770: -- START OF BEN_ACRS_PTIP_CVG_F----------------------

16766: ---------------------------------------------------------------
16767: begin
16768: l_number_of_copies := p_number_of_copies ;
16769: ---------------------------------------------------------------
16770: -- START OF BEN_ACRS_PTIP_CVG_F----------------------
16771: ---------------------------------------------------------------
16772:
16773: for l_parent_rec in c_apc_from_parent(p_pgm_id) loop
16774: --

Line 16860: -- END OF BEN_ACRS_PTIP_CVG_F----------------------

16856: --
16857: end loop;
16858: --
16859: ---------------------------------------------------------------
16860: -- END OF BEN_ACRS_PTIP_CVG_F----------------------
16861: ---------------------------------------------------------------
16862: end create_acrs_ptip_cvg_results;
16863:
16864: end ben_pd_rate_and_cvg_module;