APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_ORG_UNIT_RT_F

Line 8323: -- and tr.where_clause = l_BEN_ORG_UNIT_RT_F

8319: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8320: pqh_table_route tr
8321: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8322: and cpe.table_route_id = tr.table_route_id
8323: -- and tr.where_clause = l_BEN_ORG_UNIT_RT_F
8324: and tr.table_alias = l_table_alias
8325: and cpe.number_of_copies = 1 -- ADDITION
8326: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8327: order by information1, information2; --added for bug: 5151945

Line 8361: from BEN_ORG_UNIT_RT_F OUR

8357: c_business_group_id number,
8358: c_new_pk_id number) is
8359: select
8360: OUR.org_unit_rt_id new_value
8361: from BEN_ORG_UNIT_RT_F OUR
8362: where
8363: OUR.ORGANIZATION_ID = l_ORGANIZATION_ID and
8364: OUR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8365: OUR.business_group_id = c_business_group_id

Line 8373: from BEN_ORG_UNIT_RT_F OUR1

8369: --END TEMPIK
8370: /*TEMPIK
8371: and OUR.org_unit_rt_id <> c_new_pk_id
8372: and exists ( select null
8373: from BEN_ORG_UNIT_RT_F OUR1
8374: where
8375: OUR1.ORGANIZATION_ID = l_ORGANIZATION_ID and
8376: OUR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8377: OUR1.business_group_id = c_business_group_id

Line 8380: from BEN_ORG_UNIT_RT_F OUR2

8376: OUR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
8377: OUR1.business_group_id = c_business_group_id
8378: and OUR1.effective_start_date <= c_effective_start_date )
8379: and exists ( select null
8380: from BEN_ORG_UNIT_RT_F OUR2
8381: where
8382: OUR2.ORGANIZATION_ID = l_ORGANIZATION_ID and
8383: OUR2.VRBL_RT_PRFL_ID =l_VRBL_RT_PRFL_ID and
8384: OUR2.business_group_id = c_business_group_id

Line 8533: (p_base_table_name => 'BEN_ORG_UNIT_RT_F',

8529: if c_find_OUR_in_target%found then
8530: --
8531: --TEMPIK
8532: l_dt_rec_found := dt_api.check_min_max_dates
8533: (p_base_table_name => 'BEN_ORG_UNIT_RT_F',
8534: p_base_key_column => 'ORG_UNIT_RT_ID',
8535: p_base_key_value => l_new_value,
8536: p_from_date => l_min_esd,
8537: p_to_date => l_max_eed );

Line 8591: hr_utility.set_location(' BEN_ORG_UNIT_RT_F CREATE_ORG_UNIT_RATE ',20);

8587: end if;
8588:
8589: if l_first_rec and not l_update then
8590: -- Call Create routine.
8591: hr_utility.set_location(' BEN_ORG_UNIT_RT_F CREATE_ORG_UNIT_RATE ',20);
8592: BEN_ORG_UNIT_RATE_API.CREATE_ORG_UNIT_RATE(
8593: --
8594: P_VALIDATE => false
8595: ,P_EFFECTIVE_DATE => l_effective_date

Line 8683: hr_utility.set_location(' BEN_ORG_UNIT_RT_F UPDATE_ORG_UNIT_RATE ',30);

8679: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
8680: --
8681: IF l_update OR l_dml_operation <> 'UPDATE' THEN
8682: --UPD END
8683: hr_utility.set_location(' BEN_ORG_UNIT_RT_F UPDATE_ORG_UNIT_RATE ',30);
8684: BEN_ORG_UNIT_RATE_API.UPDATE_ORG_UNIT_RATE(
8685: --
8686: P_VALIDATE => false
8687: ,P_EFFECTIVE_DATE => l_effective_date