APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on BEN_TRANSACTION

Line 682: FROM ben_transaction trans,

678: IS
679: SELECT trans.transaction_id,
680: trans.attribute1,
681: trans.attribute2
682: FROM ben_transaction trans,
683: ben_cwb_pl_dsgn dsgn
684: WHERE trans.transaction_id IN
685: (SELECT DISTINCT pl_id
686: FROM ben_cwb_person_rates rates

Line 1074: insert into ben_transaction ( transaction_id,

1070: OPEN c_notify (p_mgr_per_id(l_count), p_group_pl_id, -1);
1071: FETCH c_notify INTO l_notify;
1072: CLOSE c_notify;
1073:
1074: insert into ben_transaction ( transaction_id,
1075: transaction_type,
1076: attribute1, -- from_person_id,
1077: attribute2, -- to_person_id,
1078: attribute3, -- to_per_in_ler_id,

Line 1089: values ( ben_transaction_s.nextval,

1085: attribute10, -- old_access_cd
1086: attribute11, -- requestor first name
1087: attribute12 -- requestor last name
1088: )
1089: values ( ben_transaction_s.nextval,
1090: 'CWBNTF',
1091: null, --p_from_person_id,
1092: l_notify.person_id,
1093: l_notify.group_per_in_ler_id,