APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CUST_TRD_PRFLS

Line 30: FROM ozf_cust_trd_prfls

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

Line 47: FROM ozf_cust_trd_prfls

43: autopay_flag,
44: claim_threshold,
45: claim_currency,
46: org_id
47: FROM ozf_cust_trd_prfls
48: WHERE cust_account_id = p_id;
49:
50: CURSOR g_party_trade_profile_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 party_id = p_id
66: AND cust_account_id IS NULL;
67:
68: l_original_total_amount NUMBER :=0;

Line 7994: FROM ozf_cust_trd_prfls tp

7990:
7991: CURSOR csr_cust_pay_unearned(cv_cust_account_id IN NUMBER) IS
7992: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type
7993: , tp.un_earned_pay_thold_amount, tp.un_earned_pay_thold_flag
7994: FROM ozf_cust_trd_prfls tp
7995: WHERE tp.cust_account_id = cv_cust_account_id;
7996:
7997: CURSOR csr_party_pay_unearned(cv_cust_account_id IN NUMBER) IS
7998: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type

Line 8000: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca

7996:
7997: CURSOR csr_party_pay_unearned(cv_cust_account_id IN NUMBER) IS
7998: SELECT tp.un_earned_pay_allow_to, tp.un_earned_pay_thold_type
7999: , tp.un_earned_pay_thold_amount, tp.un_earned_pay_thold_flag
8000: FROM ozf_cust_trd_prfls tp, hz_cust_accounts hca
8001: WHERE tp.party_id = hca.party_id
8002: AND tp.cust_account_id IS NULL
8003: AND hca.cust_account_id = cv_cust_account_id;
8004:

Line 11611: FROM ozf_cust_trd_prfls

11607: WHERE claim_id = cv_claim_id;
11608:
11609: CURSOR csr_cust_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
11610: SELECT un_earned_pay_thold_type, un_earned_pay_thold_amount, un_earned_pay_thold_flag
11611: FROM ozf_cust_trd_prfls
11612: WHERE cust_account_id = cv_cust_account_id;
11613:
11614: CURSOR csr_pty_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
11615: SELECT p.un_earned_pay_thold_type, p.un_earned_pay_thold_amount, p.un_earned_pay_thold_flag

Line 11616: FROM ozf_cust_trd_prfls p, hz_cust_accounts c

11612: WHERE cust_account_id = cv_cust_account_id;
11613:
11614: CURSOR csr_pty_trd_prfl_info(cv_cust_account_id IN NUMBER) IS
11615: SELECT p.un_earned_pay_thold_type, p.un_earned_pay_thold_amount, p.un_earned_pay_thold_flag
11616: FROM ozf_cust_trd_prfls p, hz_cust_accounts c
11617: WHERE p.party_id = c.party_id
11618: AND p.cust_account_id IS NULL
11619: AND c.cust_account_id = cv_cust_account_id;
11620: