DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_SYS_PARAMETERS

Line 2221: FROM ozf_sys_parameters;

2217:
2218: -- Fix for 5376466
2219: CURSOR csr_sysparam_defaults IS
2220: SELECT gl_date_type
2221: FROM ozf_sys_parameters;
2222:
2223: i NUMBER := 1;
2224: l_claim_obj_ver_num NUMBER;
2225: l_gl_date_type VARCHAR2(30);

Line 3194: FROM ozf_sys_parameters;

3190: WHERE claim_id = cv_claim_id;
3191:
3192: CURSOR csr_get_set_of_books IS
3193: SELECT set_of_books_id
3194: FROM ozf_sys_parameters;
3195: /*
3196: CURSOR csr_mass_setl_appr_req IS
3197: SELECT NVL(attr_available_flag, 'N')
3198: FROM ams_custom_setup_attr

Line 3224: FROM ozf_sys_parameters

3220:
3221:
3222: CURSOR csr_get_gl_date_type(cv_set_of_books_id IN NUMBER) IS
3223: SELECT gl_date_type
3224: FROM ozf_sys_parameters
3225: WHERE set_of_books_id = cv_set_of_books_id;
3226:
3227: --//Bugfix : 7661712
3228: CURSOR p_acctd_claim_amts(p_claim_id IN NUMBER) IS