DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JA_LOOKUPS

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

1181: AND transaction_type IS NULL
1182: AND order_invoice_type IS NULL
1183: AND register_code IS NULL;
1184:
1185: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS
1186: SELECT meaning
1187: FROM ja_lookups
1188: WHERE lookup_code = p_register_code
1189: AND lookup_type = cp_register_type; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */

Line 1187: FROM ja_lookups

1183: AND register_code IS NULL;
1184:
1185: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,cp_register_type ja_lookups.lookup_type%type ) IS
1186: SELECT meaning
1187: FROM ja_lookups
1188: WHERE lookup_code = p_register_code
1189: AND lookup_type = cp_register_type; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */
1190:
1191: --added by GD