DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JA_LOOKUPS

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

1193: AND transaction_type IS NULL
1194: AND order_invoice_type IS NULL
1195: AND register_code IS NULL;
1196:
1197: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS
1198: SELECT meaning
1199: FROM ja_lookups
1200: WHERE lookup_code = p_register_code
1201: AND lookup_type = cp_register_type; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */

Line 1199: FROM ja_lookups

1195: AND register_code IS NULL;
1196:
1197: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS
1198: SELECT meaning
1199: FROM ja_lookups
1200: WHERE lookup_code = p_register_code
1201: AND lookup_type = cp_register_type; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */
1202:
1203: --added by GD