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 4974: FROM igi_exp_ap_trans ap

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
4975: WHERE ap.du_id = du.du_id);
4976:
4977: l_tu_id igi_exp_dus.tu_id%TYPE;
4978: l_du_prep_id igi_exp_dus.du_by_user_id%TYPE;

Line 5027: DELETE FROM igi_exp_ap_trans

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;
5029:
5030: -- =============== START DEBUG LOG ================
5031: DEBUG_LOG_STRING (l_proc_level, 'Rem_trx_from_rej_dus.Msg5',

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

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

Line 7592: FROM igi_exp_ap_trans ap

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
7593: WHERE ap.du_id = du.du_id)
7594: AND rownum = 1;
7595:
7596:

Line 7611: FROM igi_exp_ap_trans ap

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
7612: WHERE ap.du_id = du.du_id);
7613:
7614: l_tu_id igi_exp_dus.tu_id%TYPE;
7615: l_du_id igi_exp_dus.du_id%TYPE;