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_TWO dependencies on BEN_BNFT_PRVDR_POOL_F

Line 26280: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F

26276: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26277: pqh_table_route tr
26278: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26279: and cpe.table_route_id = tr.table_route_id
26280: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F
26281: and tr.table_alias = l_table_alias
26282: and cpe.number_of_copies = 1 --ADDITION
26283: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
26284: order by information1, information2; --added for bug: 5151945

Line 26318: from BEN_BNFT_PRVDR_POOL_F BPP

26314: c_business_group_id number,
26315: c_new_pk_id number) is
26316: select
26317: BPP.bnft_prvdr_pool_id new_value
26318: from BEN_BNFT_PRVDR_POOL_F BPP
26319: where BPP.name = c_BPP_name
26320: and nvl(BPP.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999)
26321: and nvl(BPP.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999)
26322: and nvl(BPP.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999)

Line 26336: from BEN_BNFT_PRVDR_POOL_F BPP1

26332: --END TEMPIK
26333: --
26334: /* TEMPIK
26335: and exists ( select null
26336: from BEN_BNFT_PRVDR_POOL_F BPP1
26337: where BPP1.name = c_BPP_name
26338: and nvl(BPP1.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999)
26339: and nvl(BPP1.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999)
26340: and nvl(BPP1.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999)

Line 26348: from BEN_BNFT_PRVDR_POOL_F BPP2

26344: and nvl(BPP1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999)
26345: and BPP1.business_group_id = c_business_group_id
26346: and BPP1.effective_start_date <= c_effective_start_date )
26347: and exists ( select null
26348: from BEN_BNFT_PRVDR_POOL_F BPP2
26349: where BPP2.name = c_BPP_name
26350: and nvl(BPP2.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999)
26351: and nvl(BPP2.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999)
26352: and nvl(BPP2.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999)

Line 26369: from BEN_BNFT_PRVDR_POOL_F BPP

26365: c_business_group_id number,
26366: c_new_pk_id number) is
26367: select
26368: BPP.bnft_prvdr_pool_id new_value
26369: from BEN_BNFT_PRVDR_POOL_F BPP
26370: where BPP.name = c_BPP_name
26371: and BPP.business_group_id = c_business_group_id
26372: and BPP.bnft_prvdr_pool_id <> c_new_pk_id
26373: --TEMPIK

Line 26379: from BEN_BNFT_PRVDR_POOL_F BPP1

26375: and effective_end_date ;
26376: --END TEMPIK
26377: /* TEMPIK
26378: and exists ( select null
26379: from BEN_BNFT_PRVDR_POOL_F BPP1
26380: where BPP1.name = c_BPP_name
26381: and BPP1.business_group_id = c_business_group_id
26382: and BPP1.effective_start_date <= c_effective_start_date )
26383: and exists ( select null

Line 26384: from BEN_BNFT_PRVDR_POOL_F BPP2

26380: where BPP1.name = c_BPP_name
26381: and BPP1.business_group_id = c_business_group_id
26382: and BPP1.effective_start_date <= c_effective_start_date )
26383: and exists ( select null
26384: from BEN_BNFT_PRVDR_POOL_F BPP2
26385: where BPP2.name = c_BPP_name
26386: and BPP2.business_group_id = c_business_group_id
26387: and BPP2.effective_end_date >= c_effective_end_date )
26388: ;

Line 26537: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',

26533: if c_find_BPP_in_target%found then
26534: --
26535: --TEMPIK
26536: l_dt_rec_found := dt_api.check_min_max_dates
26537: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26538: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26539: p_base_key_value => l_new_value,
26540: p_from_date => l_min_esd,
26541: p_to_date => l_max_eed );

Line 26577: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',

26573: if c_find_BPP_name_in_target%found then
26574: --
26575: --TEMPIK
26576: l_dt_rec_found := dt_api.check_min_max_dates
26577: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26578: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26579: p_base_key_value => l_new_value,
26580: p_from_date => l_min_esd,
26581: p_to_date => l_max_eed );

Line 26627: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_BNFT_PRVDR_POOL_F',l_prefix || r_BPP.information170 || l_suffix);

26623: --
26624: end if ;
26625: --
26626: --
26627: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_BNFT_PRVDR_POOL_F',l_prefix || r_BPP.information170 || l_suffix);
26628: --
26629:
26630: l_effective_date := r_BPP.information2;
26631: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 26638: hr_utility.set_location(' BEN_BNFT_PRVDR_POOL_F CREATE_BENEFIT_PRVDR_POOL ',20);

26634: end if;
26635:
26636: if l_first_rec and not l_update then
26637: -- Call Create routine.
26638: hr_utility.set_location(' BEN_BNFT_PRVDR_POOL_F CREATE_BENEFIT_PRVDR_POOL ',20);
26639: BEN_BENEFIT_PRVDR_POOL_API.CREATE_BENEFIT_PRVDR_POOL(
26640: --
26641: P_VALIDATE => false
26642: ,P_EFFECTIVE_DATE => l_effective_date

Line 26736: hr_utility.set_location(' BEN_BNFT_PRVDR_POOL_F UPDATE_BENEFIT_PRVDR_POOL ',30);

26732: else
26733: --
26734: -- Call Update routine for the pk_id created in prev run .
26735: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
26736: hr_utility.set_location(' BEN_BNFT_PRVDR_POOL_F UPDATE_BENEFIT_PRVDR_POOL ',30);
26737: --UPD START
26738: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
26739: --
26740: if l_update then