DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JA_LOOKUPS

Line 803: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS

799: AND transaction_type IS NULL
800: AND order_invoice_type IS NULL
801: AND register_code IS NULL;
802:
803: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS
804: SELECT meaning
805: FROM ja_lookups
806: WHERE lookup_code = p_register_code
807: AND lookup_type = cp_register_type; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */

Line 805: FROM ja_lookups

801: AND register_code IS NULL;
802:
803: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS
804: SELECT meaning
805: FROM ja_lookups
806: WHERE lookup_code = p_register_code
807: AND lookup_type = cp_register_type; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */
808:
809: