APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_SYS_PARAMETERS

Line 250: FROM ozf_sys_parameters;

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

Line 1258: FROM ozf_sys_parameters

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

Line 1263: FROM ozf_sys_parameters

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

Line 1633: FROM ozf_sys_parameters

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

Line 1685: FROM ozf_sys_parameters_all osp

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