APPS.IGI_EXP_APPROVAL_PKG dependencies on IGI_EXP_AP_TRANS

Line 3636: FROM igi_exp_ap_trans ap

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
3637: WHERE ap.du_id = dus.du_id);
3638:
3639: -- =============== START DEBUG LOG ================
3640: DEBUG_LOG_STRING (l_proc_level, 'Reset_du_statuses.Msg4',

Line 4704: FROM igi_exp_ap_trans ap

4700: FROM igi_exp_ar_trans ar
4701: WHERE ar.du_id = du.du_id
4702: UNION
4703: SELECT 'AP'
4704: FROM igi_exp_ap_trans ap
4705: WHERE ap.du_id = du.du_id)
4706: AND rownum = 1;
4707:
4708: CURSOR c_rej_du_info(p_tu_id igi_exp_dus.tu_id%TYPE

Line 4981: FROM igi_exp_ap_trans ap

4977: FROM igi_exp_ar_trans ar
4978: WHERE ar.du_id = du.du_id
4979: UNION
4980: SELECT 'AP'
4981: FROM igi_exp_ap_trans ap
4982: WHERE ap.du_id = du.du_id);
4983:
4984: l_tu_id igi_exp_dus.tu_id%TYPE;
4985: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

Line 5034: DELETE FROM igi_exp_ap_trans

5030: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg4',
5031: 'DELETE FROM igi_exp_ar_trans --> ' || SQL%ROWCOUNT);
5032: -- =============== END DEBUG LOG ==================
5033:
5034: DELETE FROM igi_exp_ap_trans
5035: WHERE du_id = I.du_id;
5036:
5037: -- =============== START DEBUG LOG ================
5038: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg5',

Line 5039: ' DELETE FROM igi_exp_ap_trans --> ' || SQL%ROWCOUNT);

5035: WHERE du_id = I.du_id;
5036:
5037: -- =============== START DEBUG LOG ================
5038: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg5',
5039: ' DELETE FROM igi_exp_ap_trans --> ' || SQL%ROWCOUNT);
5040: -- =============== END DEBUG LOG ==================
5041:
5042: END LOOP;
5043:

Line 7601: FROM igi_exp_ap_trans ap

7597: FROM igi_exp_ar_trans ar
7598: WHERE ar.du_id = du.du_id
7599: UNION
7600: SELECT 'AP'
7601: FROM igi_exp_ap_trans ap
7602: WHERE ap.du_id = du.du_id)
7603: AND rownum = 1;
7604:
7605: