APPS.OZF_CLAIM_PVT dependencies on DUAL

Line 219: FROM DUAL;

215: WHERE split_from_claim_id = p_split_from_claim_id;
216:
217: CURSOR c_seq_csr IS
218: SELECT TO_CHAR(ams_source_codes_gen_s.NEXTVAL)
219: FROM DUAL;
220:
221: CURSOR prefix_csr (p_id in number) IS
222: SELECT source_code_suffix
223: FROM ams_custom_setups_b

Line 3731: SELECT ozf_claims_all_s.nextval FROM dual;

3727:
3728: l_auto_assign_flag varchar2(1);
3729:
3730: CURSOR claim_id_csr IS
3731: SELECT ozf_claims_all_s.nextval FROM dual;
3732:
3733: CURSOR trade_profile_csr(p_customer_account_id in number) IS
3734: SELECT vendor_id, vendor_site_id
3735: FROM ozf_cust_trd_prfls

Line 3748: FROM dual; */

3744: WHERE cust_account_id = p_customer_account_id;
3745:
3746: /* CURSOR org_id_csr IS -- R12 Enhancements
3747: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
3748: FROM dual; */
3749:
3750: CURSOR claim_number_count_csr(p_claim_number in varchar2) IS
3751: SELECT count(claim_number)
3752: FROM ozf_claims_all