APPS.IGI_EXP_APPROVAL_PKG dependencies on IGI_EXP_DU_TYPE_HEADERS

Line 6013: l_app_id igi_exp_du_type_headers.application_id%TYPE;

6009: funcmode IN VARCHAR2,
6010: result OUT NOCOPY VARCHAR2) IS
6011:
6012: l_du_id igi_exp_dus.du_id%TYPE;
6013: l_app_id igi_exp_du_type_headers.application_id%TYPE;
6014: l_order_number igi_exp_dus.du_order_number%TYPE;
6015: l_legal_number igi_exp_dus.du_legal_number%TYPE;
6016: l_failed_du VARCHAR2(510);
6017: l_failed_trx VARCHAR2(50);

Line 6046: FROM igi_exp_du_type_headers_all du_type

6042:
6043: -- Get the application id for the du
6044: SELECT du_type.application_id
6045: INTO l_app_id
6046: FROM igi_exp_du_type_headers_all du_type
6047: ,igi_exp_dus du
6048: WHERE du.du_id = l_du_id
6049: AND du.du_type_header_id = du_type.du_type_header_id;
6050: