DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_VAL_ASSIGNMENTS

Line 742: IBY_VAL_ASSIGNMENTS val_options

738: val_options.val_assignment_entity_type,
739: val.validation_set_display_name
740: FROM
741: IBY_VALIDATION_SETS_VL val,
742: IBY_VAL_ASSIGNMENTS val_options
743: WHERE
744: val.validation_set_code = val_options.validation_set_code
745: AND val.validation_level_code = 'DOCUMENT'
746: AND (val_options.val_assignment_entity_type = 'METHOD'

Line 2207: IBY_VAL_ASSIGNMENTS val_options,

2203: val_options.val_assignment_entity_type,
2204: val.validation_set_display_name
2205: FROM
2206: IBY_VALIDATION_SETS_VL val,
2207: IBY_VAL_ASSIGNMENTS val_options,
2208: IBY_DOCS_PAYABLE_GT docs,
2209: IBY_VALIDATION_VALUES vld_val
2210: WHERE
2211: docs.document_payable_id = p_document_payable_id

Line 4400: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.

4396: | NOTES:
4397: |
4398: *---------------------------------------------------------------------*/
4399: PROCEDURE getParamValue (
4400: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.
4401: validation_assignment_id%TYPE,
4402: p_validation_set_code IN IBY_VALIDATION_SETS_VL.
4403: validation_set_code%TYPE,
4404: p_validation_param_code IN IBY_VALIDATION_PARAMS_B.

Line 4419: from iby_val_assignments va,

4415: 'VARCHAR2', val_param_varchar2_value,
4416: 'NUMBER', val_param_number_value,
4417: 'DATE', val_param_date_value)
4418: into p_value
4419: from iby_val_assignments va,
4420: iby_validation_values vv,
4421: iby_validation_params_vl vp
4422: where va.validation_set_code = p_validation_set_code
4423: and va.validation_assignment_id = p_validation_assign_id