APPS.OZF_AUTOPAY_PVT dependencies on OZF_CUST_TRD_PRFLS_ALL

Line 47: FROM ozf_cust_trd_prfls_all

43: autopay_flag,
44: claim_threshold,
45: claim_currency,
46: org_id
47: FROM ozf_cust_trd_prfls_all
48: WHERE site_use_id = p_id;
49:
50: CURSOR g_customer_info_csr(p_id in number) IS
51: SELECT trade_profile_id,

Line 1419: UPDATE OZF_CUST_TRD_PRFLS_ALL

1415: DBMS_SQL.close_cursor(l_emp_csr);
1416:
1417: -- update the trade_profiles together
1418: FORALL i IN 1..l_trd_prof_tbl.COUNT
1419: UPDATE OZF_CUST_TRD_PRFLS_ALL
1420: SET last_paid_date = SYSDATE
1421: WHERE trade_profile_id = l_trd_prof_tbl(i) ;
1422:
1423: