APPS.OZF_AUTOPAY_PVT dependencies on OZF_CUST_TRD_PRFLS

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 64: FROM ozf_cust_trd_prfls

60: autopay_flag,
61: claim_threshold,
62: claim_currency,
63: org_id
64: FROM ozf_cust_trd_prfls
65: WHERE cust_account_id = p_id
66: AND site_use_id IS NULL;
67:
68: CURSOR g_party_trade_info_csr(p_id in number) IS

Line 82: FROM ozf_cust_trd_prfls

78: autopay_flag,
79: claim_threshold,
80: claim_currency,
81: org_id
82: FROM ozf_cust_trd_prfls
83: WHERE party_id = p_id
84: AND cust_account_id IS NULL;
85:
86:

Line 1507: UPDATE OZF_CUST_TRD_PRFLS_ALL

1503: DBMS_SQL.close_cursor(l_emp_csr);
1504:
1505: -- update the trade_profiles together
1506: FORALL i IN 1..l_trd_prof_tbl.COUNT
1507: UPDATE OZF_CUST_TRD_PRFLS_ALL
1508: SET last_paid_date = SYSDATE
1509: WHERE trade_profile_id = l_trd_prof_tbl(i) ;
1510:
1511: