APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_LBR_MMBR_RT_F

Line 7363: l_lbr_mmbr_flag ben_lbr_mmbr_rt_f.lbr_mmbr_flag%type;

7359: ,p_prefix_suffix_cd in varchar2 default null
7360: ) is
7361: --
7362: l_VRBL_RT_PRFL_ID number;
7363: l_lbr_mmbr_flag ben_lbr_mmbr_rt_f.lbr_mmbr_flag%type;
7364: cursor c_unique_LMM(l_table_alias varchar2) is
7365: select distinct cpe.information1,
7366: cpe.information2,
7367: cpe.information3,

Line 7373: -- and tr.where_clause = l_BEN_LBR_MMBR_RT_F

7369: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7370: pqh_table_route tr
7371: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7372: and cpe.table_route_id = tr.table_route_id
7373: -- and tr.where_clause = l_BEN_LBR_MMBR_RT_F
7374: and tr.table_alias = l_table_alias
7375: and cpe.number_of_copies = 1 -- ADDITION
7376: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7377: order by information1, information2; --added for bug: 5151945

Line 7411: from BEN_LBR_MMBR_RT_F LMM

7407: c_business_group_id number,
7408: c_new_pk_id number) is
7409: select
7410: LMM.lbr_mmbr_rt_id new_value
7411: from BEN_LBR_MMBR_RT_F LMM
7412: where
7413: LMM.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
7414: LMM.business_group_id = c_business_group_id
7415: and LMM.lbr_mmbr_rt_id <> c_new_pk_id

Line 7423: from BEN_LBR_MMBR_RT_F LMM1

7419: and effective_end_date ;
7420: --END TEMPIK
7421: /*TEMPIK
7422: and exists ( select null
7423: from BEN_LBR_MMBR_RT_F LMM1
7424: where
7425: LMM1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
7426: LMM1.business_group_id = c_business_group_id
7427: and LMM1.effective_start_date <= c_effective_start_date

Line 7430: from BEN_LBR_MMBR_RT_F LMM2

7426: LMM1.business_group_id = c_business_group_id
7427: and LMM1.effective_start_date <= c_effective_start_date
7428: and LMM1.lbr_mmbr_flag = l_lbr_mmbr_flag )
7429: and exists ( select null
7430: from BEN_LBR_MMBR_RT_F LMM2
7431: where
7432: LMM2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
7433: LMM2.business_group_id = c_business_group_id
7434: and LMM2.effective_end_date >= c_effective_end_date

Line 7567: (p_base_table_name => 'BEN_LBR_MMBR_RT_F',

7563: if c_find_LMM_in_target%found then
7564: --
7565: --TEMPIK
7566: l_dt_rec_found := dt_api.check_min_max_dates
7567: (p_base_table_name => 'BEN_LBR_MMBR_RT_F',
7568: p_base_key_column => 'LBR_MMBR_RT_ID',
7569: p_base_key_value => l_new_value,
7570: p_from_date => l_min_esd,
7571: p_to_date => l_max_eed );

Line 7625: hr_utility.set_location(' BEN_LBR_MMBR_RT_F CREATE_LABOR_MEMBER_RATE ',20);

7621: end if;
7622:
7623: if l_first_rec and not l_update then
7624: -- Call Create routine.
7625: hr_utility.set_location(' BEN_LBR_MMBR_RT_F CREATE_LABOR_MEMBER_RATE ',20);
7626: BEN_LABOR_MEMBER_RATE_API.CREATE_LABOR_MEMBER_RATE(
7627: --
7628: P_VALIDATE => false
7629: ,P_EFFECTIVE_DATE => l_effective_date

Line 7717: hr_utility.set_location(' BEN_LBR_MMBR_RT_F UPDATE_LABOR_MEMBER_RATE ',30);

7713: --
7714: IF l_update OR l_dml_operation <> 'UPDATE' THEN
7715: --UPD END
7716: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
7717: hr_utility.set_location(' BEN_LBR_MMBR_RT_F UPDATE_LABOR_MEMBER_RATE ',30);
7718: BEN_LABOR_MEMBER_RATE_API.UPDATE_LABOR_MEMBER_RATE(
7719: --
7720: P_VALIDATE => false
7721: ,P_EFFECTIVE_DATE => l_effective_date