APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_PL_REGN_F

Line 14005: -- and tr.where_clause = l_BEN_PL_REGN_F

14001: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14002: pqh_table_route tr
14003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14004: and cpe.table_route_id = tr.table_route_id
14005: -- and tr.where_clause = l_BEN_PL_REGN_F
14006: and tr.table_alias = l_table_alias
14007: and cpe.number_of_copies = 1 -- ADDITION
14008: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14009: order by information1, information2; --added for bug: 5151945

Line 14043: from BEN_PL_REGN_F PRG

14039: c_business_group_id number,
14040: c_new_pk_id number) is
14041: select
14042: PRG.pl_regn_id new_value
14043: from BEN_PL_REGN_F PRG
14044: where
14045: nvl(PRG.PL_ID,-999) = nvl(l_PL_ID,-999) and
14046: PRG.REGN_ID = l_REGN_ID and
14047: nvl(PRG.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and

Line 14056: from BEN_PL_REGN_F PRG1

14052: and effective_end_date ;
14053: --END TEMPIK
14054: /*TEMPIK
14055: and exists ( select null
14056: from BEN_PL_REGN_F PRG1
14057: where
14058: nvl(PRG1.PL_ID,-999) = nvl(l_PL_ID,-999) and
14059: PRG1.REGN_ID = l_REGN_ID and
14060: nvl(PRG1.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and

Line 14064: from BEN_PL_REGN_F PRG2

14060: nvl(PRG1.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and
14061: PRG1.business_group_id = c_business_group_id
14062: and PRG1.effective_start_date <= c_effective_start_date )
14063: and exists ( select null
14064: from BEN_PL_REGN_F PRG2
14065: where
14066: nvl(PRG2.PL_ID,-999) = nvl(l_PL_ID,-999) and
14067: PRG2.REGN_ID = l_REGN_ID and
14068: nvl(PRG2.RPTG_GRP_ID,-999) = nvl(l_RPTG_GRP_ID,-999) and

Line 14255: (p_base_table_name => 'BEN_PL_REGN_F',

14251: if c_find_PRG_in_target%found then
14252: --
14253: --TEMPIK
14254: l_dt_rec_found := dt_api.check_min_max_dates
14255: (p_base_table_name => 'BEN_PL_REGN_F',
14256: p_base_key_column => 'PL_REGN_ID',
14257: p_base_key_value => l_new_value,
14258: p_from_date => l_min_esd,
14259: p_to_date => l_max_eed );

Line 14314: hr_utility.set_location(' BEN_PL_REGN_F CREATE_PLAN_REGULATION ',20);

14310: end if;
14311:
14312: if l_first_rec and not l_update then
14313: -- Call Create routine.
14314: hr_utility.set_location(' BEN_PL_REGN_F CREATE_PLAN_REGULATION ',20);
14315: BEN_PLAN_REGULATION_API.CREATE_PLAN_REGULATION(
14316: --
14317: P_VALIDATE => false
14318: ,P_EFFECTIVE_DATE => l_effective_date

Line 14386: hr_utility.set_location(' BEN_PL_REGN_F UPDATE_PLAN_REGULATION ',30);

14382: else
14383: --
14384: -- Call Update routine for the pk_id created in prev run .
14385: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
14386: hr_utility.set_location(' BEN_PL_REGN_F UPDATE_PLAN_REGULATION ',30);
14387: --UPD START
14388: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
14389: --
14390: if l_update then