APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_GRADE_RT_F

Line 1209: -- and tr.where_clause = l_BEN_GRADE_RT_F

1205: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1206: pqh_table_route tr
1207: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1208: and cpe.table_route_id = tr.table_route_id
1209: -- and tr.where_clause = l_BEN_GRADE_RT_F
1210: and tr.table_alias = l_table_alias
1211: and cpe.number_of_copies = 1 -- ADDITION
1212: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
1213: order by information1, information2; --added for bug: 5151945

Line 1247: from BEN_GRADE_RT_F GRR

1243: c_business_group_id number,
1244: c_new_pk_id number) is
1245: select
1246: GRR.grade_rt_id new_value
1247: from BEN_GRADE_RT_F GRR
1248: where
1249: GRR.GRADE_ID = l_GRADE_ID and
1250: GRR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
1251: GRR.ORDR_NUM = l_ORDR_NUM and

Line 1260: from BEN_GRADE_RT_F GRR1

1256: and effective_end_date ;
1257: --END TEMPIK
1258: /*TEMPIK
1259: and exists ( select null
1260: from BEN_GRADE_RT_F GRR1
1261: where
1262: GRR1.GRADE_ID = l_GRADE_ID and
1263: GRR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
1264: GRR1.ORDR_NUM = l_ORDR_NUM and

Line 1268: from BEN_GRADE_RT_F GRR2

1264: GRR1.ORDR_NUM = l_ORDR_NUM and
1265: GRR1.business_group_id = c_business_group_id
1266: and GRR1.effective_start_date <= c_effective_start_date )
1267: and exists ( select null
1268: from BEN_GRADE_RT_F GRR2
1269: where
1270: GRR2.GRADE_ID = l_GRADE_ID and
1271: GRR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
1272: GRR2.ORDR_NUM = l_ORDR_NUM and

Line 1424: (p_base_table_name => 'BEN_GRADE_RT_F',

1420: if c_find_GRR_in_target%found then
1421: --
1422: --TEMPIK
1423: l_dt_rec_found := dt_api.check_min_max_dates
1424: (p_base_table_name => 'BEN_GRADE_RT_F',
1425: p_base_key_column => 'GRADE_RT_ID',
1426: p_base_key_value => l_new_value,
1427: p_from_date => l_min_esd,
1428: p_to_date => l_max_eed );

Line 1482: hr_utility.set_location(' BEN_GRADE_RT_F CREATE_GRADE_RATE ',20);

1478: end if;
1479:
1480: if l_first_rec and not l_update then
1481: -- Call Create routine.
1482: hr_utility.set_location(' BEN_GRADE_RT_F CREATE_GRADE_RATE ',20);
1483: BEN_GRADE_RATE_API.CREATE_GRADE_RATE(
1484: --
1485: P_VALIDATE => false
1486: ,P_EFFECTIVE_DATE => l_effective_date

Line 1575: hr_utility.set_location(' BEN_GRADE_RT_F UPDATE_GRADE_RATE ',30);

1571: --
1572: IF l_update OR l_dml_operation <> 'UPDATE' THEN
1573: --UPD END
1574: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
1575: hr_utility.set_location(' BEN_GRADE_RT_F UPDATE_GRADE_RATE ',30);
1576: BEN_GRADE_RATE_API.UPDATE_GRADE_RATE(
1577: --
1578: P_VALIDATE => false
1579: ,P_EFFECTIVE_DATE => l_effective_date