204: CURSOR get_trx_reason_def_rule_mo_csr(
205: c_org_id PO_SYSTEM_PARAMETERS.ORG_ID%TYPE)
206: IS
207: SELECT global_attribute3
208: FROM PO_SYSTEM_PARAMETERS_ALL
209: WHERE org_id = c_org_id;
210:
211: CURSOR get_trx_reason_def_rule_so_csr
212: IS
210:
211: CURSOR get_trx_reason_def_rule_so_csr
212: IS
213: SELECT global_attribute3
214: FROM PO_SYSTEM_PARAMETERS_ALL;
215:
216:
217: BEGIN
218:
261:
262: CURSOR get_trx_reason_code_so_csr
263: IS
264: SELECT global_attribute1
265: FROM PO_SYSTEM_PARAMETERS_ALL;
266:
267: CURSOR get_trx_reason_code_mo_csr(
268: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
269: IS
264: SELECT global_attribute1
265: FROM PO_SYSTEM_PARAMETERS_ALL;
266:
267: CURSOR get_trx_reason_code_mo_csr(
268: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
269: IS
270: SELECT global_attribute1
271: FROM PO_SYSTEM_PARAMETERS_ALL
272: WHERE org_id = c_org_id;
267: CURSOR get_trx_reason_code_mo_csr(
268: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
269: IS
270: SELECT global_attribute1
271: FROM PO_SYSTEM_PARAMETERS_ALL
272: WHERE org_id = c_org_id;
273:
274: BEGIN
275: