DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on BEN_TRANSACTION

Line 1181: from ben_transaction asgn

1177: select job.name job
1178: , pos.name position
1179: , grade.name grade
1180: , people_group.group_name
1181: from ben_transaction asgn
1182: , per_jobs_tl job
1183: , hr_all_positions_f_tl pos
1184: , per_grades_tl grade
1185: , pay_people_groups people_group

Line 1202: FROM ben_transaction trans,

1198: IS
1199: SELECT trans.transaction_id,
1200: trans.attribute1,
1201: trans.attribute2
1202: FROM ben_transaction trans,
1203: ben_cwb_pl_dsgn dsgn
1204: WHERE trans.transaction_id IN
1205: (SELECT DISTINCT pl_id
1206: FROM ben_cwb_person_rates rates