APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 3140: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

3136: | NOTES:
3137: |
3138: *---------------------------------------------------------------------*/
3139: PROCEDURE initInstructionData (
3140: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
3141: payment_instruction_id%type,
3142: x_instruction_rec IN OUT NOCOPY instructionRecType
3143: )
3144: IS

Line 3153: CURSOR c_instruction_rec (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

3149: * Picking up all the instruction fields which need to be validated.
3150: * Note: If any field is to be modified in the query below, the same
3151: * field in 'instructionRecType' in the spec should be changed accordingly.
3152: */
3153: CURSOR c_instruction_rec (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
3154: payment_instruction_id%type)
3155: RETURN instructionRecType
3156: IS
3157: SELECT

Line 3162: IBY_PAY_INSTRUCTIONS_ALL instr

3158: instr.payment_instruction_id ins_id,
3159: 0 ins_amount,
3160: 0 ins_document_count
3161: FROM
3162: IBY_PAY_INSTRUCTIONS_ALL instr
3163: WHERE
3164: instr.payment_instruction_id = p_instr_id;
3165:
3166: BEGIN