APPS.OZF_CLAIM_PVT dependencies on OZF_CUST_TRD_PRFLS

Line 602: FROM ozf_cust_trd_prfls

598: x_return_status OUT NOCOPY VARCHAR2)
599: IS
600: CURSOR days_due_csr(p_customer_account_id in number) IS
601: SELECT days_due
602: FROM ozf_cust_trd_prfls
603: WHERE cust_account_id = p_customer_account_id;
604:
605: -- fix for bug 5042046
606: CURSOR sys_parameters_days_due_csr IS

Line 1507: FROM OZF_CUST_TRD_PRFLS

1503: --trade profile based on the account id
1504: CURSOR get_cst_trd_prfl_wo_thr_csr(p_cust_account_id IN NUMBER) IS
1505: SELECT pos_write_off_threshold
1506: , neg_write_off_threshold
1507: FROM OZF_CUST_TRD_PRFLS
1508: WHERE cust_account_id = p_cust_account_id;
1509:
1510: --Cursor to get the Threshold amounts from the customers
1511: --Tradeprofile based on the party_id

Line 1515: FROM OZF_CUST_TRD_PRFLS

1511: --Tradeprofile based on the party_id
1512: CURSOR get_prt_trd_prfl_wo_thr_csr(p_party_id IN NUMBER) IS
1513: SELECT pos_write_off_threshold
1514: , neg_write_off_threshold
1515: FROM OZF_CUST_TRD_PRFLS
1516: WHERE party_id = p_party_id
1517: AND (pos_write_off_threshold is not null
1518: AND neg_write_off_threshold is not null)
1519: AND rownum = 1;

Line 3354: FROM ozf_cust_trd_prfls

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
3355: WHERE cust_account_id = p_customer_account_id;
3356:
3357: l_trade_profile trade_profile_csr%ROWTYPE;
3358: