APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CUST_TRD_PRFLS

Line 33: FROM ozf_cust_trd_prfls

29: autopay_flag,
30: claim_threshold,
31: claim_currency,
32: org_id
33: FROM ozf_cust_trd_prfls
34: WHERE site_use_id = p_id;
35:
36: CURSOR g_cust_trade_profile_csr(p_id in number) IS
37: SELECT trade_profile_id,

Line 50: FROM ozf_cust_trd_prfls

46: autopay_flag,
47: claim_threshold,
48: claim_currency,
49: org_id
50: FROM ozf_cust_trd_prfls
51: WHERE cust_account_id = p_id;
52:
53: CURSOR g_party_trade_profile_csr(p_id in number) IS
54: SELECT trade_profile_id,

Line 67: FROM ozf_cust_trd_prfls

63: autopay_flag,
64: claim_threshold,
65: claim_currency,
66: org_id
67: FROM ozf_cust_trd_prfls
68: WHERE party_id = p_id
69: AND cust_account_id IS NULL;
70:
71: l_original_total_amount NUMBER :=0;

Line 6307: FROM ozf_cust_trd_prfls tp

6303:
6304: CURSOR csr_cust_pay_unearned(cv_cust_account_id IN NUMBER) IS
6305: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type
6306: , tp.un_earned_pay_thold_amount, tp.un_earned_pay_thold_flag
6307: FROM ozf_cust_trd_prfls tp
6308: WHERE tp.cust_account_id = cv_cust_account_id;
6309:
6310: CURSOR csr_party_pay_unearned(cv_cust_account_id IN NUMBER) IS
6311: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type

Line 6313: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca

6309:
6310: CURSOR csr_party_pay_unearned(cv_cust_account_id IN NUMBER) IS
6311: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type
6312: , tp.un_earned_pay_thold_amount, tp.un_earned_pay_thold_flag
6313: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca
6314: WHERE tp.party_id = hca.party_id
6315: AND tp.cust_account_id IS NULL
6316: AND hca.cust_account_id = cv_cust_account_id;
6317:

Line 9359: FROM ozf_cust_trd_prfls

9355: WHERE claim_id = cv_claim_id;
9356:
9357: CURSOR csr_cust_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
9358: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag
9359: FROM ozf_cust_trd_prfls
9360: WHERE cust_account_id = cv_cust_account_id;
9361:
9362: CURSOR csr_pty_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
9363: SELECT p.un_earned_pay_thold_type, p.un_earned_pay_thold_amount, p.un_earned_pay_thold_flag

Line 9364: FROM ozf_cust_trd_prfls p, hz_cust_accounts c

9360: WHERE cust_account_id = cv_cust_account_id;
9361:
9362: CURSOR csr_pty_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
9363: SELECT p.un_earned_pay_thold_type, p.un_earned_pay_thold_amount, p.un_earned_pay_thold_flag
9364: FROM ozf_cust_trd_prfls p, hz_cust_accounts c
9365: WHERE p.party_id = c.party_id
9366: AND p.cust_account_id IS NULL
9367: AND c.cust_account_id = cv_cust_account_id;
9368: