DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_VAL_ASSIGNMENTS

Line 637: IBY_VAL_ASSIGNMENTS val_options,

633: val_options.val_assignment_entity_type,
634: val.validation_set_display_name
635: FROM
636: IBY_VALIDATION_SETS_VL val,
637: IBY_VAL_ASSIGNMENTS val_options,
638: IBY_DOCS_PAYABLE_ALL docs,
639: IBY_SYS_PMT_PROFILES_B sys_prof,
640: IBY_ACCT_PMT_PROFILES_B acct_prof,
641: IBY_TRANSMIT_CONFIGS_B txconf,

Line 1635: IBY_VAL_ASSIGNMENTS val_options,

1631: val_options.val_assignment_entity_type,
1632: val.validation_set_display_name
1633: FROM
1634: IBY_VALIDATION_SETS_VL val,
1635: IBY_VAL_ASSIGNMENTS val_options,
1636: IBY_DOCS_PAYABLE_GT docs
1637: WHERE
1638: docs.document_payable_id = p_document_payable_id
1639: AND

Line 4315: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.

4311: | NOTES:
4312: |
4313: *---------------------------------------------------------------------*/
4314: PROCEDURE getParamValue (
4315: p_validation_assign_id IN IBY_VAL_ASSIGNMENTS.
4316: validation_assignment_id%TYPE,
4317: p_validation_set_code IN IBY_VALIDATION_SETS_VL.
4318: validation_set_code%TYPE,
4319: p_validation_param_code IN IBY_VALIDATION_PARAMS_B.

Line 4334: from iby_val_assignments va,

4330: 'VARCHAR2', val_param_varchar2_value,
4331: 'NUMBER', val_param_number_value,
4332: 'DATE', val_param_date_value)
4333: into p_value
4334: from iby_val_assignments va,
4335: iby_validation_values vv,
4336: iby_validation_params_vl vp
4337: where va.validation_set_code = p_validation_set_code
4338: and va.validation_assignment_id = p_validation_assign_id