DBA Data[Home] [Help]

APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BEN_TRANSACTION

Line 550: from ben_transaction txn

546:
547: cursor Csr_person_perf(l_assignment_id In Number, l_perf_revw_strt_dt In Varchar2, l_emp_interview_typ_cd In Varchar2)
548: is
549: select txn.attribute3 rating
550: from ben_transaction txn
551: where txn.transaction_id = l_assignment_id
552: and txn.transaction_type = 'CWBPERF'|| trim(l_perf_revw_strt_dt) || trim(l_emp_interview_typ_cd);
553:
554: Cursor Csr_pl_dsgn_info(l_group_per_in_ler_id In Number)

Line 696: from ben_transaction txn

692: select txn.attribute3 change_reason
693: ,to_number(txn.attribute5) job_id
694: ,to_number(txn.attribute6) position_id
695: ,to_number(txn.attribute7) grade_id
696: from ben_transaction txn
697: where txn.transaction_id = l_assignment_id
698: and txn.transaction_type = 'CWBASG'|| trim(l_asg_updt_eff_date);
699:
700: cursor c_job (bg_id In Number) is