APPS.IGI_EXP_APPROVAL_PKG dependencies on IGI_EXP_DU_TYPE_HEADERS

Line 6006: l_app_id igi_exp_du_type_headers.application_id%TYPE;

6002: funcmode IN VARCHAR2,
6003: result OUT NOCOPY VARCHAR2) IS
6004:
6005: l_du_id igi_exp_dus.du_id%TYPE;
6006: l_app_id igi_exp_du_type_headers.application_id%TYPE;
6007: l_order_number igi_exp_dus.du_order_number%TYPE;
6008: l_legal_number igi_exp_dus.du_legal_number%TYPE;
6009: l_failed_du VARCHAR2(510);
6010: l_failed_trx VARCHAR2(50);

Line 6039: FROM igi_exp_du_type_headers_all du_type

6035:
6036: -- Get the application id for the du
6037: SELECT du_type.application_id
6038: INTO l_app_id
6039: FROM igi_exp_du_type_headers_all du_type
6040: ,igi_exp_dus du
6041: WHERE du.du_id = l_du_id
6042: AND du.du_type_header_id = du_type.du_type_header_id;
6043: