DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_SYS_PARAMETERS

Line 2215: FROM ozf_sys_parameters;

2211:
2212: -- Fix for 5376466
2213: CURSOR csr_sysparam_defaults IS
2214: SELECT gl_date_type
2215: FROM ozf_sys_parameters;
2216:
2217: i NUMBER := 1;
2218: l_claim_obj_ver_num NUMBER;
2219: l_gl_date_type VARCHAR2(30);

Line 3071: FROM ozf_sys_parameters;

3067: WHERE claim_id = cv_claim_id;
3068:
3069: CURSOR csr_get_set_of_books IS
3070: SELECT set_of_books_id
3071: FROM ozf_sys_parameters;
3072:
3073: CURSOR csr_mass_setl_appr_req IS
3074: SELECT NVL(attr_available_flag, 'N')
3075: FROM ams_custom_setup_attr

Line 3086: FROM ozf_sys_parameters

3082:
3083:
3084: CURSOR csr_get_gl_date_type(cv_set_of_books_id IN NUMBER) IS
3085: SELECT gl_date_type
3086: FROM ozf_sys_parameters
3087: WHERE set_of_books_id = cv_set_of_books_id;
3088:
3089: --//Bugfix : 7439145
3090: CURSOR p_acctd_claim_amts(p_claim_id IN NUMBER) IS