APPS.BEN_CWB_EMP_ELIG dependencies on BEN_TRANSACTION

Line 740: update ben_transaction

736: wf_engine.SetItemAttrText(itemtype => itemtype
737: , itemkey => itemkey
738: , aname => 'APPROVER_NAME'
739: , avalue => l_approver_name );
740: update ben_transaction
741: set attribute36 = l_approver_name,
742: attribute38 = to_char(sysdate,'yyyy/mm/dd'),
743: attribute35 = c_next_approver_out.person_id
744: where attribute1 = itemkey

Line 929: from ben_transaction tran_tbl,

925: ,tran_tbl.attribute16 o4_change_status
926: ,tran_tbl.attribute29 o4_person_rate_id
927: ,tran_tbl.attribute37 ovrd_person_id
928: ,pil.per_in_ler_stat_cd ler_stat
929: from ben_transaction tran_tbl,
930: ben_per_in_ler pil
931: where tran_tbl.attribute1 = itemkey
932: and tran_tbl.transaction_type = 'EMPELIGEMP'
933: and to_number(tran_tbl.attribute2) = pil.per_in_ler_id;

Line 1055: update ben_transaction

1051: IS
1052: l_proc varchar2(61) := g_package||':'||'remove_transaction';
1053: BEGIN
1054: hr_utility.set_location ('Entering '||l_proc,180);
1055: update ben_transaction
1056: set STATUS='PROCESSED'
1057: where attribute1 = itemkey
1058: and transaction_type='EMPELIGHDR';
1059: update ben_transaction

Line 1059: update ben_transaction

1055: update ben_transaction
1056: set STATUS='PROCESSED'
1057: where attribute1 = itemkey
1058: and transaction_type='EMPELIGHDR';
1059: update ben_transaction
1060: set STATUS='PROCESSED'
1061: where transaction_type = 'EMPELIGEMP'
1062: and attribute1 = itemkey;
1063: result := 'COMPLETE:';