APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_SYS_PARAMETERS

Line 252: FROM ozf_sys_parameters;

248: SELECT autopay_flag
249: , autopay_periodicity
250: , autopay_periodicity_type
251: , days_due
252: FROM ozf_sys_parameters;
253:
254: l_autopay_flag VARCHAR2(1);
255: l_autopay_periodicity NUMBER;
256: l_autopay_periodicity_type VARCHAR2(30);

Line 1260: FROM ozf_sys_parameters

1256: l_return_status VARCHAR2(1);
1257:
1258: CURSOR csr_payment_term(cv_books_id IN NUMBER) IS
1259: SELECT ap_payment_term_id
1260: FROM ozf_sys_parameters
1261: WHERE set_of_books_id = cv_books_id;
1262:
1263: CURSOR csr_get_gl_date_type(cv_set_of_books_id IN NUMBER) IS
1264: SELECT gl_date_type

Line 1265: FROM ozf_sys_parameters

1261: WHERE set_of_books_id = cv_books_id;
1262:
1263: CURSOR csr_get_gl_date_type(cv_set_of_books_id IN NUMBER) IS
1264: SELECT gl_date_type
1265: FROM ozf_sys_parameters
1266: WHERE set_of_books_id = cv_set_of_books_id;
1267:
1268: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1269: SELECT user_status_id

Line 1635: FROM ozf_sys_parameters

1631: l_return_status VARCHAR2(1);
1632:
1633: CURSOR csr_payment_term(cv_books_id IN NUMBER) IS
1634: SELECT ap_payment_term_id
1635: FROM ozf_sys_parameters
1636: WHERE set_of_books_id = cv_books_id;
1637:
1638: --R12.1 Price Protection Enhancement : Added the source object class
1639: CURSOR csr_claim_settle(cv_claim_id IN NUMBER) IS

Line 1687: FROM ozf_sys_parameters_all osp

1683:
1684: -- Bug4308173
1685: CURSOR claim_gl_posting_csr(p_id in number) IS
1686: SELECT osp.post_to_gl
1687: FROM ozf_sys_parameters_all osp
1688: , ozf_claims_all oc
1689: WHERE osp.org_id = oc.org_id
1690: AND oc.claim_id = p_id;
1691: l_post_to_gl VARCHAR2(1);

Line 2312: , ozf_sys_parameters org

2308:
2309: CURSOR csr_function_currency IS
2310: SELECT gs.currency_code
2311: FROM gl_sets_of_books gs
2312: , ozf_sys_parameters org
2313: WHERE org.set_of_books_id = gs.set_of_books_id
2314: AND org.org_id = p_claim_org_id;
2315:
2316: CURSOR c_claim_line_util_dtls IS

Line 2526: FROM ozf_sys_parameters os, ozf_claims_all oc

2522:
2523: -- Added For Rule Based Settlement ER
2524: CURSOR csr_rule_based_approval(p_claim_id IN NUMBER) IS
2525: SELECT NVL(approval_matched_credit, 'F'),NVL(approval_new_credit,'F')
2526: FROM ozf_sys_parameters os, ozf_claims_all oc
2527: WHERE oc.org_id = os.org_id
2528: and oc.claim_id = p_claim_id;
2529:
2530: l_app_match_cr VARCHAR2(1);

Line 3130: FROM ozf_sys_parameters os, ozf_claims_all oc

3126:
3127: -- Added For Rule Based Settlement ER
3128: CURSOR csr_rule_based_approval(p_claim_id IN NUMBER) IS
3129: SELECT NVL(approval_matched_credit, 'F'),NVL(approval_new_credit,'F')
3130: FROM ozf_sys_parameters os, ozf_claims_all oc
3131: WHERE oc.org_id = os.org_id
3132: and oc.claim_id = p_claim_id;
3133:
3134: l_app_match_cr VARCHAR2(1);