APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_BNF_CTFN_F

Line 1173: -- and tr.where_clause = l_BEN_PL_BNF_CTFN_F

1169: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1170: pqh_table_route tr
1171: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1172: and cpe.table_route_id = tr.table_route_id
1173: -- and tr.where_clause = l_BEN_PL_BNF_CTFN_F
1174: and tr.table_alias = l_table_alias
1175: and cpe.number_of_copies = 1 --ADDITION
1176: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
1177: order by information1, information2; --added for bug: 5151945

Line 1211: from BEN_PL_BNF_CTFN_F PCX

1207: c_business_group_id number,
1208: c_new_pk_id number) is
1209: select
1210: PCX.pl_bnf_ctfn_id new_value
1211: from BEN_PL_BNF_CTFN_F PCX
1212: where
1213: nvl(PCX.PL_ID,-999) = nvl(l_PL_ID,-999) and
1214: nvl(PCX.BNF_CTFN_TYP_CD,-999) = nvl(l_BNF_CTFN_TYP_CD,-999) and
1215: nvl(PCX.BNF_TYP_CD,-999) = nvl(l_BNF_TYP_CD,-999) and

Line 1225: from BEN_PL_BNF_CTFN_F PCX1

1221: and effective_end_date ;
1222: --END TEMPIK
1223: /* TEMPIK
1224: and exists ( select null
1225: from BEN_PL_BNF_CTFN_F PCX1
1226: where
1227: nvl(PCX1.PL_ID,-999) = nvl(l_PL_ID,-999) and
1228: nvl(PCX1.BNF_CTFN_TYP_CD,-999) = nvl(l_BNF_CTFN_TYP_CD,-999) and
1229: nvl(PCX1.BNF_TYP_CD,-999) = nvl(l_BNF_TYP_CD,-999) and

Line 1234: from BEN_PL_BNF_CTFN_F PCX2

1230: nvl(PCX1.RLSHP_TYP_CD,-999) = nvl(l_RLSHP_TYP_CD,-999) and
1231: PCX1.business_group_id = c_business_group_id
1232: and PCX1.effective_start_date <= c_effective_start_date )
1233: and exists ( select null
1234: from BEN_PL_BNF_CTFN_F PCX2
1235: where
1236: nvl(PCX2.PL_ID,-999) = nvl(l_PL_ID,-999) and
1237: nvl(PCX2.BNF_CTFN_TYP_CD,-999) = nvl(l_BNF_CTFN_TYP_CD,-999) and
1238: nvl(PCX2.BNF_TYP_CD,-999) = nvl(l_BNF_TYP_CD,-999) and

Line 1381: (p_base_table_name => 'BEN_PL_BNF_CTFN_F',

1377: if c_find_PCX_in_target%found then
1378: --
1379: --TEMPIK
1380: l_dt_rec_found := dt_api.check_min_max_dates
1381: (p_base_table_name => 'BEN_PL_BNF_CTFN_F',
1382: p_base_key_column => 'PL_BNF_CTFN_ID',
1383: p_base_key_value => l_new_value,
1384: p_from_date => l_min_esd,
1385: p_to_date => l_max_eed );

Line 1443: hr_utility.set_location(' BEN_PL_BNF_CTFN_F CREATE_PLAN_BENEFICIARY_CTFN ',20);

1439:
1440: if l_first_rec and not l_update then
1441:
1442: -- Call Create routine.
1443: hr_utility.set_location(' BEN_PL_BNF_CTFN_F CREATE_PLAN_BENEFICIARY_CTFN ',20);
1444: BEN_PLAN_BENEFICIARY_CTFN_API.CREATE_PLAN_BENEFICIARY_CTFN(
1445: --
1446: P_VALIDATE => false
1447: ,P_EFFECTIVE_DATE => l_effective_date

Line 1514: hr_utility.set_location(' BEN_PL_BNF_CTFN_F UPDATE_PLAN_BENEFICIARY_CTFN ',30);

1510: else
1511: --
1512: -- Call Update routine for the pk_id created in prev run .
1513: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
1514: hr_utility.set_location(' BEN_PL_BNF_CTFN_F UPDATE_PLAN_BENEFICIARY_CTFN ',30);
1515: --UPD START
1516: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
1517: --
1518: if l_update then