APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_PAY_INSTRUCTIONS_ALL

Line 3189: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.

3185: | NOTES:
3186: |
3187: *---------------------------------------------------------------------*/
3188: PROCEDURE initInstructionData (
3189: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.
3190: payment_instruction_id%type,
3191: x_instruction_rec IN OUT NOCOPY instructionRecType
3192: )
3193: IS

Line 3202: CURSOR c_instruction_rec (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.

3198: * Picking up all the instruction fields which need to be validated.
3199: * Note: If any field is to be modified in the query below, the same
3200: * field in 'instructionRecType' in the spec should be changed accordingly.
3201: */
3202: CURSOR c_instruction_rec (p_instr_id IBY_PAY_INSTRUCTIONS_ALL.
3203: payment_instruction_id%type)
3204: RETURN instructionRecType
3205: IS
3206: SELECT

Line 3211: IBY_PAY_INSTRUCTIONS_ALL instr

3207: instr.payment_instruction_id ins_id,
3208: 0 ins_amount,
3209: 0 ins_document_count
3210: FROM
3211: IBY_PAY_INSTRUCTIONS_ALL instr
3212: WHERE
3213: instr.payment_instruction_id = p_instr_id;
3214:
3215: BEGIN