eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_CMBN_PTIP_OPT_F

Line 2943: -- and tr.where_clause = l_BEN_CMBN_PTIP_OPT_F

2939: from ben_copy_entity_results cpe,
2940: pqh_table_route tr
2941: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2942: and cpe.table_route_id = tr.table_route_id
2943: -- and tr.where_clause = l_BEN_CMBN_PTIP_OPT_F
2944: and tr.table_alias = l_table_alias
2945: and cpe.number_of_copies = 1 -- ADDITION
2946: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2947: order by information1, information2; --added for bug: 5151945

Line 2981: from BEN_CMBN_PTIP_OPT_F CPT

2977: c_business_group_id number,
2978: c_new_pk_id number) is
2979: select
2980: CPT.cmbn_ptip_opt_id new_value
2981: from BEN_CMBN_PTIP_OPT_F CPT
2982: where CPT.name = c_CPT_name and
2983: nvl(CPT.OPT_ID,-999) = nvl(l_OPT_ID,-999) and
2984: nvl(CPT.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2985: CPT.business_group_id = c_business_group_id

Line 2993: from BEN_CMBN_PTIP_OPT_F CPT1

2989: and effective_end_date ;
2990: --END TEMPIK
2991: /*TEMPIK
2992: and exists ( select null
2993: from BEN_CMBN_PTIP_OPT_F CPT1
2994: where CPT1.name = c_CPT_name and
2995: nvl(CPT1.OPT_ID,-999) = nvl(l_OPT_ID,-999) and
2996: nvl(CPT1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2997: CPT1.business_group_id = c_business_group_id

Line 3000: from BEN_CMBN_PTIP_OPT_F CPT2

2996: nvl(CPT1.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
2997: CPT1.business_group_id = c_business_group_id
2998: and CPT1.effective_start_date <= c_effective_start_date )
2999: and exists ( select null
3000: from BEN_CMBN_PTIP_OPT_F CPT2
3001: where CPT2.name = c_CPT_name and
3002: nvl(CPT2.OPT_ID,-999) = nvl(l_OPT_ID,-999) and
3003: nvl(CPT2.PGM_ID,-999) = nvl(l_PGM_ID,-999) and
3004: CPT2.business_group_id = c_business_group_id

Line 3019: from BEN_CMBN_PTIP_OPT_F CPT

3015: c_business_group_id number,
3016: c_new_pk_id number) is
3017: select
3018: CPT.cmbn_ptip_opt_id new_value
3019: from BEN_CMBN_PTIP_OPT_F CPT
3020: where CPT.name = c_CPT_name and
3021: CPT.business_group_id = c_business_group_id
3022: and CPT.cmbn_ptip_opt_id <> c_new_pk_id
3023: and exists ( select null

Line 3024: from BEN_CMBN_PTIP_OPT_F CPT1

3020: where CPT.name = c_CPT_name and
3021: CPT.business_group_id = c_business_group_id
3022: and CPT.cmbn_ptip_opt_id <> c_new_pk_id
3023: and exists ( select null
3024: from BEN_CMBN_PTIP_OPT_F CPT1
3025: where CPT1.name = c_CPT_name and
3026: CPT1.business_group_id = c_business_group_id
3027: and CPT1.effective_start_date <= c_effective_start_date )
3028: and exists ( select null

Line 3029: from BEN_CMBN_PTIP_OPT_F CPT2

3025: where CPT1.name = c_CPT_name and
3026: CPT1.business_group_id = c_business_group_id
3027: and CPT1.effective_start_date <= c_effective_start_date )
3028: and exists ( select null
3029: from BEN_CMBN_PTIP_OPT_F CPT2
3030: where CPT2.name = c_CPT_name and
3031: CPT2.business_group_id = c_business_group_id
3032: and CPT2.effective_end_date >= c_effective_end_date )
3033: ;

Line 3158: (p_base_table_name => 'BEN_CMBN_PTIP_OPT_F',

3154: if c_find_CPT_in_target%found then
3155: --
3156: --TEMPIK
3157: l_dt_rec_found := dt_api.check_min_max_dates
3158: (p_base_table_name => 'BEN_CMBN_PTIP_OPT_F',
3159: p_base_key_column => 'CMBN_PTIP_OPT_ID',
3160: p_base_key_value => l_new_value,
3161: p_from_date => l_min_esd,
3162: p_to_date => l_max_eed );

Line 3235: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_PTIP_OPT_F' ,l_prefix || r_CPT.INFORMATION170 || l_suffix);

3231: l_first_rec := true ;
3232: --
3233: end if ;
3234: --
3235: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_CMBN_PTIP_OPT_F' ,l_prefix || r_CPT.INFORMATION170 || l_suffix);
3236: --
3237:
3238: l_effective_date := r_CPT.information2;
3239: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 3246: hr_utility.set_location(' BEN_CMBN_PTIP_OPT_F CREATE_CMBN_PTIP_OPT ',20);

3242: end if;
3243:
3244: if l_first_rec and not l_update then
3245: -- Call Create routine.
3246: hr_utility.set_location(' BEN_CMBN_PTIP_OPT_F CREATE_CMBN_PTIP_OPT ',20);
3247: BEN_CMBN_PTIP_OPT_API.CREATE_CMBN_PTIP_OPT(
3248: --
3249: P_VALIDATE => false
3250: ,P_EFFECTIVE_DATE => l_effective_date

Line 3336: hr_utility.set_location(' BEN_CMBN_PTIP_OPT_F UPDATE_CMBN_PTIP_OPT ',30);

3332: --
3333: IF l_update OR l_dml_operation <> 'UPDATE' THEN
3334: -- Call Update routine for the pk_id created in prev run .
3335: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
3336: hr_utility.set_location(' BEN_CMBN_PTIP_OPT_F UPDATE_CMBN_PTIP_OPT ',30);
3337: BEN_CMBN_PTIP_OPT_API.UPDATE_CMBN_PTIP_OPT(
3338: --
3339: P_VALIDATE => false
3340: ,P_EFFECTIVE_DATE => l_effective_date