APPS.IGI_EXP_APPROVAL_PKG dependencies on IGI_EXP_AR_TRANS

Line 3632: FROM igi_exp_ar_trans ar

3628: SET dus.du_status = 'APP'
3629: WHERE dus.du_status = 'REJ'
3630: AND dus.tu_id = l_tu_id
3631: AND EXISTS (SELECT 'AR'
3632: FROM igi_exp_ar_trans ar
3633: WHERE ar.du_id = dus.du_id
3634: UNION
3635: SELECT 'AP'
3636: FROM igi_exp_ap_trans ap

Line 4970: FROM igi_exp_ar_trans ar

4966: WHERE tu_id = p_tu_id
4967: AND du_status = 'REJ'
4968: AND du_by_user_id = p_du_preparer_id
4969: AND EXISTS (SELECT 'AR'
4970: FROM igi_exp_ar_trans ar
4971: WHERE ar.du_id = du.du_id
4972: UNION
4973: SELECT 'AP'
4974: FROM igi_exp_ap_trans ap

Line 5019: DELETE FROM igi_exp_ar_trans

5015:
5016: FOR I IN c_rej_dus(l_tu_id,l_du_prep_id)
5017: LOOP
5018:
5019: DELETE FROM igi_exp_ar_trans
5020: WHERE du_id = I.du_id;
5021:
5022: -- =============== START DEBUG LOG ================
5023: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg4',

Line 5024: 'DELETE FROM igi_exp_ar_trans --> ' || SQL%ROWCOUNT);

5020: WHERE du_id = I.du_id;
5021:
5022: -- =============== START DEBUG LOG ================
5023: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg4',
5024: 'DELETE FROM igi_exp_ar_trans --> ' || SQL%ROWCOUNT);
5025: -- =============== END DEBUG LOG ==================
5026:
5027: DELETE FROM igi_exp_ap_trans
5028: WHERE du_id = I.du_id;

Line 7588: FROM igi_exp_ar_trans ar

7584: FROM igi_exp_dus du
7585: WHERE tu_id = p_tu_id
7586: AND du_status = 'REJ'
7587: AND EXISTS (SELECT 'AR'
7588: FROM igi_exp_ar_trans ar
7589: WHERE ar.du_id = du.du_id
7590: UNION
7591: SELECT 'AP'
7592: FROM igi_exp_ap_trans ap

Line 7607: FROM igi_exp_ar_trans ar

7603: WHERE tu_id = p_tu_id
7604: AND du_status = 'REJ'
7605: AND du_by_user_id = p_du_preparer_id
7606: AND EXISTS (SELECT 'AR'
7607: FROM igi_exp_ar_trans ar
7608: WHERE ar.du_id = du.du_id
7609: UNION
7610: SELECT 'AP'
7611: FROM igi_exp_ap_trans ap