DBA Data[Home] [Help]

APPS.FPA_VALIDATION_PVT dependencies on FPA_LOOKUPS_V

Line 51: FROM FPA_LOOKUPS_V

47:
48: CURSOR OBJ_VAL_TYPE_CSR (VALIDATION_SET IN VARCHAR2,
49: OBJ_VALIDATION_TYPE IN VARCHAR2) IS
50: SELECT 'T'
51: FROM FPA_LOOKUPS_V
52: WHERE LOOKUP_TYPE = VALIDATION_SET
53: AND LOOKUP_CODE = OBJ_VALIDATION_TYPE;
54:
55: CURSOR HDR_VAL_TYPE_CSR (VALIDATION_SET IN VARCHAR2) IS

Line 57: FROM FPA_LOOKUPS_V

53: AND LOOKUP_CODE = OBJ_VALIDATION_TYPE;
54:
55: CURSOR HDR_VAL_TYPE_CSR (VALIDATION_SET IN VARCHAR2) IS
56: SELECT 'T'
57: FROM FPA_LOOKUPS_V
58: WHERE LOOKUP_TYPE = VALIDATION_SET;
59:
60: CURSOR SEV_TYPE_CSR (SEV_CODE IN VARCHAR2) IS
61: SELECT 'T'

Line 62: FROM FPA_LOOKUPS_V

58: WHERE LOOKUP_TYPE = VALIDATION_SET;
59:
60: CURSOR SEV_TYPE_CSR (SEV_CODE IN VARCHAR2) IS
61: SELECT 'T'
62: FROM FPA_LOOKUPS_V
63: WHERE LOOKUP_TYPE = 'FPA_SEVERITY_TYPES'
64: AND LOOKUP_CODE = SEV_CODE;
65: BEGIN
66: