33: --start:| 16-Oct-2007 cklee -- Fixed bug:6502786 |
34: CURSOR c_account_derivation IS
35: select account_derivation,
36: PAY_DIST_SET_ID
37: from OKL_SYS_ACCT_OPTS;
38:
39: l_account_derivation OKL_SYS_ACCT_OPTS_ALL.account_derivation%type := NULL;
40: l_PAY_DIST_SET_ID OKL_SYS_ACCT_OPTS_ALL.PAY_DIST_SET_ID%type := NULL;
41: --end:| 16-Oct-2007 cklee -- Fixed bug:6502786 |
35: select account_derivation,
36: PAY_DIST_SET_ID
37: from OKL_SYS_ACCT_OPTS;
38:
39: l_account_derivation OKL_SYS_ACCT_OPTS_ALL.account_derivation%type := NULL;
40: l_PAY_DIST_SET_ID OKL_SYS_ACCT_OPTS_ALL.PAY_DIST_SET_ID%type := NULL;
41: --end:| 16-Oct-2007 cklee -- Fixed bug:6502786 |
42:
43: CURSOR c_invoice_hdr IS
36: PAY_DIST_SET_ID
37: from OKL_SYS_ACCT_OPTS;
38:
39: l_account_derivation OKL_SYS_ACCT_OPTS_ALL.account_derivation%type := NULL;
40: l_PAY_DIST_SET_ID OKL_SYS_ACCT_OPTS_ALL.PAY_DIST_SET_ID%type := NULL;
41: --end:| 16-Oct-2007 cklee -- Fixed bug:6502786 |
42:
43: CURSOR c_invoice_hdr IS
44: SELECT *