DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_SYSTEM_PARAMS

Line 1122: -- : RMUNJULU 3061751 16-OCT-2003 Changed code to get delink_yn from OKL_SYSTEM_PARAMS_ALL_V

1118: -- Parameters :
1119: -- Version : 1.0
1120: -- History : RMUNJULU 3061751 27-AUG-2003 Created
1121: -- : RMUNJULU 3061751 14-OCT-2003 Added code to get delink_yn from table
1122: -- : RMUNJULU 3061751 16-OCT-2003 Changed code to get delink_yn from OKL_SYSTEM_PARAMS_ALL_V
1123: -- : RMUNJULU 23-DEC-03 SERVICE K UPDATES
1124: -- : RMUNJULU 05-JAN-04 SERVICE K UPDATES
1125: --
1126: -- End of comments

Line 1143: FROM OKL_SYSTEM_PARAMS SYP;

1139:
1140: -- Get the delink_yn value set for the org
1141: CURSOR get_setup_values_csr IS
1142: SELECT SYP.delink_yn
1143: FROM OKL_SYSTEM_PARAMS SYP;
1144:
1145: l_delink_needed VARCHAR2(1) := 'N';
1146: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1147: l_wf_source VARCHAR2(20);

Line 3640: FROM OKL_SYSTEM_PARAMS;

3636: l_inv_acct_code OKC_RULES_B.rule_information1%TYPE;
3637: --akrangan Bug 5526955 fix start
3638: CURSOR check_accrual_previous_csr IS
3639: SELECT NVL(CHK_ACCRUAL_PREVIOUS_MNTH_YN,'N')
3640: FROM OKL_SYSTEM_PARAMS;
3641:
3642: l_accrual_previous_mnth_yn VARCHAR2(3);
3643: --akrangan Bug 5526955 fix start
3644: FUNCTION get_invoice_number(

Line 4891: FROM OKL_SYSTEM_PARAMS;

4887:
4888: --rmunjulu 4769094
4889: CURSOR check_accrual_previous_csr IS
4890: SELECT NVL(CHK_ACCRUAL_PREVIOUS_MNTH_YN,'N')
4891: FROM OKL_SYSTEM_PARAMS;
4892:
4893: --rmunjulu 4769094
4894: l_accrual_previous_mnth_yn VARCHAR2(3);
4895: l_accrual_adjst_date DATE;