634: WHERE source_code = l_src_code;
635:
636: CURSOR reason_cur IS
637: SELECT reason_id
638: FROM mtl_transaction_reasons_val_v
639: WHERE reason_name LIKE p_reason_code;
640:
641: CURSOR arg_cur IS
642: SELECT argument_text
1894: WHERE transaction_header_id = header_id;
1895:
1896: CURSOR reason_cur IS
1897: SELECT reason_id
1898: FROM mtl_transaction_reasons_val_v
1899: WHERE reason_name LIKE p_reason_code;
1900:
1901:
1902: BEGIN
2120: WHERE transaction_header_id = header_id;
2121:
2122: CURSOR reason_cur IS
2123: SELECT reason_id
2124: FROM mtl_transaction_reasons_val_v
2125: WHERE reason_name LIKE p_reason_code;
2126:
2127: BEGIN
2128:
2556: WHERE source_code = l_src_code;
2557:
2558: CURSOR reason_cur IS
2559: SELECT reason_id
2560: FROM mtl_transaction_reasons_val_v
2561: WHERE reason_name LIKE p_reason_name;
2562:
2563: CURSOR arg_cur IS
2564: SELECT argument_text