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 26178: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F

26174: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26175: pqh_table_route tr
26176: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26177: and cpe.table_route_id = tr.table_route_id
26178: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F
26179: and tr.table_alias = l_table_alias
26180: and cpe.number_of_copies = 1 --ADDITION
26181: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
26182: order by information1, information2; --added for bug: 5151945

Line 26216: from BEN_BNFT_PRVDR_POOL_F BPP

26212: c_business_group_id number,
26213: c_new_pk_id number) is
26214: select
26215: BPP.bnft_prvdr_pool_id new_value
26216: from BEN_BNFT_PRVDR_POOL_F BPP
26217: where BPP.name = c_BPP_name
26218: and nvl(BPP.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999)
26219: and nvl(BPP.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999)
26220: and nvl(BPP.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999)

Line 26234: from BEN_BNFT_PRVDR_POOL_F BPP1

26230: --END TEMPIK
26231: --
26232: /* TEMPIK
26233: and exists ( select null
26234: from BEN_BNFT_PRVDR_POOL_F BPP1
26235: where BPP1.name = c_BPP_name
26236: and nvl(BPP1.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999)
26237: and nvl(BPP1.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999)
26238: and nvl(BPP1.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999)

Line 26246: from BEN_BNFT_PRVDR_POOL_F BPP2

26242: and nvl(BPP1.PTIP_ID,-999) = nvl(l_PTIP_ID,-999)
26243: and BPP1.business_group_id = c_business_group_id
26244: and BPP1.effective_start_date <= c_effective_start_date )
26245: and exists ( select null
26246: from BEN_BNFT_PRVDR_POOL_F BPP2
26247: where BPP2.name = c_BPP_name
26248: and nvl(BPP2.CMBN_PLIP_ID,-999) = nvl(l_CMBN_PLIP_ID,-999)
26249: and nvl(BPP2.CMBN_PTIP_ID,-999) = nvl(l_CMBN_PTIP_ID,-999)
26250: and nvl(BPP2.CMBN_PTIP_OPT_ID,-999) = nvl(l_CMBN_PTIP_OPT_ID,-999)

Line 26267: from BEN_BNFT_PRVDR_POOL_F BPP

26263: c_business_group_id number,
26264: c_new_pk_id number) is
26265: select
26266: BPP.bnft_prvdr_pool_id new_value
26267: from BEN_BNFT_PRVDR_POOL_F BPP
26268: where BPP.name = c_BPP_name
26269: and BPP.business_group_id = c_business_group_id
26270: and BPP.bnft_prvdr_pool_id <> c_new_pk_id
26271: --TEMPIK

Line 26277: from BEN_BNFT_PRVDR_POOL_F BPP1

26273: and effective_end_date ;
26274: --END TEMPIK
26275: /* TEMPIK
26276: and exists ( select null
26277: from BEN_BNFT_PRVDR_POOL_F BPP1
26278: where BPP1.name = c_BPP_name
26279: and BPP1.business_group_id = c_business_group_id
26280: and BPP1.effective_start_date <= c_effective_start_date )
26281: and exists ( select null

Line 26282: from BEN_BNFT_PRVDR_POOL_F BPP2

26278: where BPP1.name = c_BPP_name
26279: and BPP1.business_group_id = c_business_group_id
26280: and BPP1.effective_start_date <= c_effective_start_date )
26281: and exists ( select null
26282: from BEN_BNFT_PRVDR_POOL_F BPP2
26283: where BPP2.name = c_BPP_name
26284: and BPP2.business_group_id = c_business_group_id
26285: and BPP2.effective_end_date >= c_effective_end_date )
26286: ;

Line 26435: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',

26431: if c_find_BPP_in_target%found then
26432: --
26433: --TEMPIK
26434: l_dt_rec_found := dt_api.check_min_max_dates
26435: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26436: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26437: p_base_key_value => l_new_value,
26438: p_from_date => l_min_esd,
26439: p_to_date => l_max_eed );

Line 26475: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',

26471: if c_find_BPP_name_in_target%found then
26472: --
26473: --TEMPIK
26474: l_dt_rec_found := dt_api.check_min_max_dates
26475: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26476: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26477: p_base_key_value => l_new_value,
26478: p_from_date => l_min_esd,
26479: p_to_date => l_max_eed );

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

26521: --
26522: end if ;
26523: --
26524: --
26525: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_BNFT_PRVDR_POOL_F',l_prefix || r_BPP.information170 || l_suffix);
26526: --
26527:
26528: l_effective_date := r_BPP.information2;
26529: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

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

26532: end if;
26533:
26534: if l_first_rec and not l_update then
26535: -- Call Create routine.
26536: hr_utility.set_location(' BEN_BNFT_PRVDR_POOL_F CREATE_BENEFIT_PRVDR_POOL ',20);
26537: BEN_BENEFIT_PRVDR_POOL_API.CREATE_BENEFIT_PRVDR_POOL(
26538: --
26539: P_VALIDATE => false
26540: ,P_EFFECTIVE_DATE => l_effective_date

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

26630: else
26631: --
26632: -- Call Update routine for the pk_id created in prev run .
26633: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
26634: hr_utility.set_location(' BEN_BNFT_PRVDR_POOL_F UPDATE_BENEFIT_PRVDR_POOL ',30);
26635: --UPD START
26636: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
26637: --
26638: if l_update then