APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_TRANSACTION

Line 217: FROM ben_transaction ptxn

213: , to_number (NULL), per.fte_factor)), per.grd_mid_point * per.grade_annulization_factor), temp.pct_decs) new_comparatio
214: ,
215: (
216: SELECT ptxn.attribute3
217: FROM ben_transaction ptxn
218: WHERE ptxn.transaction_id = per.assignment_id
219: AND ptxn.transaction_type = 'CWBPERF'
220: || temp.perf_date
221: || temp.perf_type

Line 232: FROM ben_transaction atxn

228: , jobdef.segment5 job_flex5
229: ,
230: (
231: SELECT to_number (atxn.attribute5)
232: FROM ben_transaction atxn
233: WHERE atxn.transaction_id = per.assignment_id
234: AND atxn.transaction_type = 'CWBASG'
235: || temp.asg_date
236: ) proposed_job_id

Line 241: FROM ben_transaction atxn

237: , postl.position_id position_id
238: ,
239: (
240: SELECT to_number (atxn.attribute6)
241: FROM ben_transaction atxn
242: WHERE atxn.transaction_id = per.assignment_id
243: AND atxn.transaction_type = 'CWBASG'
244: || temp.asg_date
245: ) proposed_position_id

Line 250: FROM ben_transaction atxn

246: , grdtl.grade_id grade_id
247: ,
248: (
249: SELECT to_number (atxn.attribute7)
250: FROM ben_transaction atxn
251: WHERE atxn.transaction_id = per.assignment_id
252: AND atxn.transaction_type = 'CWBASG'
253: || temp.asg_date
254: ) proposed_grade_id

Line 259: FROM ben_transaction atxn

255: , per.people_group_name people_group
256: ,
257: (
258: SELECT grp.group_name
259: FROM ben_transaction atxn
260: , pay_people_groups grp
261: WHERE atxn.transaction_id = per.assignment_id
262: AND atxn.transaction_type = 'CWBASG'
263: || temp.asg_date

Line 725: FROM ben_transaction txn

721: , to_number (NULL)) opt4_salary_comp
722: ,
723: (
724: SELECT txn.attribute3
725: FROM ben_transaction txn
726: WHERE txn.transaction_id = per.assignment_id
727: AND txn.transaction_type = 'CWBASG'
728: || temp.asg_date
729: AND txn.attribute3 IS NOT NULL