APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_CMBN_PTIP_F

Line 2465: -- and tr.where_clause = l_BEN_CMBN_PTIP_F

2461: from ben_copy_entity_results cpe,
2462: pqh_table_route tr
2463: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2464: and cpe.table_route_id = tr.table_route_id
2465: -- and tr.where_clause = l_BEN_CMBN_PTIP_F
2466: and tr.table_alias = l_table_alias
2467: and cpe.number_of_copies = 1 -- ADDITION
2468: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2469: order by information1, information2; --added for bug: 5151945

Line 2503: from BEN_CMBN_PTIP_F CBP

2499: c_business_group_id number,
2500: c_new_pk_id number) is
2501: select
2502: CBP.cmbn_ptip_id new_value
2503: from BEN_CMBN_PTIP_F CBP
2504: where CBP.name = c_CBP_name and
2505: nvl(CBP.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2506: CBP.business_group_id = c_business_group_id
2507: and CBP.cmbn_ptip_id <> c_new_pk_id

Line 2514: from BEN_CMBN_PTIP_F CBP1

2510: and effective_end_date ;
2511: --END TEMPIK
2512: /*TEMPIK
2513: and exists ( select null
2514: from BEN_CMBN_PTIP_F CBP1
2515: where CBP1.name = c_CBP_name and
2516: nvl(CBP1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2517: CBP1.business_group_id = c_business_group_id
2518: and CBP1.effective_start_date <= c_effective_start_date )

Line 2520: from BEN_CMBN_PTIP_F CBP2

2516: nvl(CBP1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2517: CBP1.business_group_id = c_business_group_id
2518: and CBP1.effective_start_date <= c_effective_start_date )
2519: and exists ( select null
2520: from BEN_CMBN_PTIP_F CBP2
2521: where CBP2.name = c_CBP_name and
2522: nvl(CBP2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2523: CBP2.business_group_id = c_business_group_id
2524: and CBP2.effective_end_date >= c_effective_end_date )

Line 2538: from BEN_CMBN_PTIP_F CBP

2534: c_business_group_id number,
2535: c_new_pk_id number) is
2536: select
2537: CBP.cmbn_ptip_id new_value
2538: from BEN_CMBN_PTIP_F CBP
2539: where CBP.name = c_CBP_name and
2540: CBP.business_group_id = c_business_group_id
2541: and CBP.cmbn_ptip_id <> c_new_pk_id
2542: and exists ( select null

Line 2543: from BEN_CMBN_PTIP_F CBP1

2539: where CBP.name = c_CBP_name and
2540: CBP.business_group_id = c_business_group_id
2541: and CBP.cmbn_ptip_id <> c_new_pk_id
2542: and exists ( select null
2543: from BEN_CMBN_PTIP_F CBP1
2544: where CBP1.name = c_CBP_name and
2545: CBP1.business_group_id = c_business_group_id
2546: and CBP1.effective_start_date <= c_effective_start_date )
2547: and exists ( select null

Line 2548: from BEN_CMBN_PTIP_F CBP2

2544: where CBP1.name = c_CBP_name and
2545: CBP1.business_group_id = c_business_group_id
2546: and CBP1.effective_start_date <= c_effective_start_date )
2547: and exists ( select null
2548: from BEN_CMBN_PTIP_F CBP2
2549: where CBP2.name = c_CBP_name and
2550: CBP2.business_group_id = c_business_group_id
2551: and CBP2.effective_end_date >= c_effective_end_date )
2552: ;

Line 2674: (p_base_table_name => 'BEN_CMBN_PTIP_F',

2670: fetch c_find_CBP_in_target into l_new_value ;
2671: if c_find_CBP_in_target%found then
2672: --TEMPIK
2673: l_dt_rec_found := dt_api.check_min_max_dates
2674: (p_base_table_name => 'BEN_CMBN_PTIP_F',
2675: p_base_key_column => 'CMBN_PTIP_ID',
2676: p_base_key_value => l_new_value,
2677: p_from_date => l_min_esd,
2678: p_to_date => l_max_eed );

Line 2751: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_PTIP_F' ,l_prefix || r_CBP.INFORMATION170 || l_suffix);

2747: l_first_rec := true ;
2748: --
2749: end if ;
2750: --
2751: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_PTIP_F' ,l_prefix || r_CBP.INFORMATION170 || l_suffix);
2752: --
2753:
2754: l_effective_date := r_CBP.information2;
2755: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 2762: hr_utility.set_location(' BEN_CMBN_PTIP_F CREATE_CMBN_PTIP ',20);

2758: end if;
2759:
2760: if l_first_rec and not l_update then
2761: -- Call Create routine.
2762: hr_utility.set_location(' BEN_CMBN_PTIP_F CREATE_CMBN_PTIP ',20);
2763: BEN_CMBN_PTIP_API.CREATE_CMBN_PTIP(
2764: --
2765: P_VALIDATE => false
2766: ,P_EFFECTIVE_DATE => l_effective_date

Line 2829: hr_utility.set_location(' BEN_CMBN_PTIP_F UPDATE_CMBN_PTIP ',30);

2825: else
2826: --
2827: -- Call Update routine for the pk_id created in prev run .
2828: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2829: hr_utility.set_location(' BEN_CMBN_PTIP_F UPDATE_CMBN_PTIP ',30);
2830: BEN_CMBN_PTIP_API.UPDATE_CMBN_PTIP(
2831: --
2832: P_VALIDATE => false
2833: ,P_EFFECTIVE_DATE => l_effective_date