APPS.OZF_CLAIM_PVT dependencies on DUAL

Line 212: FROM DUAL;

208: WHERE split_from_claim_id = p_split_from_claim_id;
209:
210: CURSOR c_seq_csr IS
211: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)
212: FROM DUAL;
213:
214: CURSOR prefix_csr (p_id in number) IS
215: SELECT source_code_suffix
216: FROM ams_custom_setups_b

Line 3350: SELECT ozf_claims_all_s.nextval FROM dual;

3346:
3347: l_auto_assign_flag varchar2(1);
3348:
3349: CURSOR claim_id_csr IS
3350: SELECT ozf_claims_all_s.nextval FROM dual;
3351:
3352: CURSOR trade_profile_csr(p_customer_account_id in number) IS
3353: SELECT vendor_id, vendor_site_id
3354: FROM ozf_cust_trd_prfls

Line 3367: FROM dual; */

3363: WHERE cust_account_id = p_customer_account_id;
3364:
3365: /* CURSOR org_id_csr IS -- R12 Enhancements
3366: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
3367: FROM dual; */
3368:
3369: CURSOR claim_number_count_csr(p_claim_number in varchar2) IS
3370: SELECT count(claim_number)
3371: FROM ozf_claims_all