DBA Data[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JA_LOOKUPS

Line 2030: cp_register_type ja_lookups.lookup_type%type) IS

2026: AND order_invoice_type IS NULL
2027: AND register_code IS NULL;
2028:
2029: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,
2030: cp_register_type ja_lookups.lookup_type%type) IS
2031: SELECT meaning
2032: FROM ja_lookups
2033: WHERE lookup_code = p_register_code
2034: AND lookup_type = cp_register_type;

Line 2032: FROM ja_lookups

2028:
2029: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2,
2030: cp_register_type ja_lookups.lookup_type%type) IS
2031: SELECT meaning
2032: FROM ja_lookups
2033: WHERE lookup_code = p_register_code
2034: AND lookup_type = cp_register_type;
2035: CURSOR for_modvat_percentage(v_org_id NUMBER, v_location_id NUMBER) IS
2036: SELECT MODVAT_REVERSE_PERCENT