APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_POPL_ACTN_TYP_F

Line 21273: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F

21269: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21270: pqh_table_route tr
21271: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21272: and cpe.table_route_id = tr.table_route_id
21273: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F
21274: and tr.table_alias = l_table_alias
21275: and cpe.number_of_copies = 1 -- ADDITION
21276: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21277: order by information1, information2; --added for bug: 5151945

Line 21310: from BEN_POPL_ACTN_TYP_F PAT

21306: c_business_group_id number,
21307: c_new_pk_id number) is
21308: select
21309: PAT.popl_actn_typ_id new_value
21310: from BEN_POPL_ACTN_TYP_F PAT
21311: where NVL(PAT.PGM_ID,-999) = nvl(l_PGM_ID,-999)
21312: and NVL(PAT.PL_ID,-999) = nvl(l_PL_ID ,-999)
21313: and PAT.ACTN_TYP_ID = l_ACTN_TYP_ID
21314: and PAT.business_group_id = c_business_group_id

Line 21322: from BEN_POPL_ACTN_TYP_F PAT1

21318: and effective_end_date ;
21319: --END TEMPIK
21320: /*
21321: and exists ( select null
21322: from BEN_POPL_ACTN_TYP_F PAT1
21323: where NVL(PAT1.PGM_ID,-999) = nvl(l_PGM_ID,-999)
21324: and NVL(PAT1.PL_ID,-999) = nvl(l_PL_ID ,-999)
21325: and PAT1.ACTN_TYP_ID = l_ACTN_TYP_ID
21326: and PAT1.business_group_id = c_business_group_id

Line 21329: from BEN_POPL_ACTN_TYP_F PAT2

21325: and PAT1.ACTN_TYP_ID = l_ACTN_TYP_ID
21326: and PAT1.business_group_id = c_business_group_id
21327: and PAT1.effective_start_date <= c_effective_start_date )
21328: and exists ( select null
21329: from BEN_POPL_ACTN_TYP_F PAT2
21330: where NVL(PAT2.PGM_ID,-999) = nvl(l_PGM_ID,-999)
21331: and NVL(PAT2.PL_ID,-999) = nvl(l_PL_ID ,-999)
21332: and PAT2.ACTN_TYP_ID = l_ACTN_TYP_ID
21333: and PAT2.business_group_id = c_business_group_id

Line 21484: (p_base_table_name => 'BEN_POPL_ACTN_TYP_F',

21480: if c_find_PAT_in_target%found then
21481: --
21482: --TEMPIK
21483: l_dt_rec_found := dt_api.check_min_max_dates
21484: (p_base_table_name => 'BEN_POPL_ACTN_TYP_F',
21485: p_base_key_column => 'POPL_ACTN_TYP_ID',
21486: p_base_key_value => l_new_value,
21487: p_from_date => l_min_esd,
21488: p_to_date => l_max_eed );

Line 21543: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F CREATE_POPL_ACTION_TYPE ',20);

21539: end if;
21540:
21541: if l_first_rec and not l_update then
21542: -- Call Create routine.
21543: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F CREATE_POPL_ACTION_TYPE ',20);
21544: BEN_POPL_ACTION_TYPE_API.CREATE_POPL_ACTION_TYPE(
21545: --
21546: P_VALIDATE => false
21547: ,P_EFFECTIVE_DATE => l_effective_date

Line 21611: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F UPDATE_POPL_ACTION_TYPE ',30);

21607: else
21608: --
21609: -- Call Update routine for the pk_id created in prev run .
21610: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
21611: hr_utility.set_location(' BEN_POPL_ACTN_TYP_F UPDATE_POPL_ACTION_TYPE ',30);
21612: --UPD START
21613: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21614: --
21615: if l_update then