APPS.OZF_RESALE_WF_PVT dependencies on OZF_CUST_TRD_PRFLS

Line 2788: FROM ozf_cust_trd_prfls

2784:
2785: CURSOR header_tolerance_account_csr (p_cust_account_id NUMBER)IS
2786: SELECT header_tolerance_operand,
2787: header_tolerance_calc_code
2788: FROM ozf_cust_trd_prfls
2789: WHERE cust_account_id = p_cust_account_id;
2790:
2791: CURSOR header_tolerance_party_csr (p_party_id NUMBER)IS
2792: SELECT header_tolerance_operand,

Line 2794: FROM ozf_cust_trd_prfls

2790:
2791: CURSOR header_tolerance_party_csr (p_party_id NUMBER)IS
2792: SELECT header_tolerance_operand,
2793: header_tolerance_calc_code
2794: FROM ozf_cust_trd_prfls
2795: WHERE party_id = p_party_id
2796: and cust_account_id IS NULL;
2797:
2798: CURSOR line_tolerance_sys_csr IS

Line 2806: FROM ozf_cust_trd_prfls

2802:
2803: CURSOR line_tolerance_account_csr (p_cust_account_id NUMBER)IS
2804: SELECT line_tolerance_operand,
2805: line_tolerance_calc_code
2806: FROM ozf_cust_trd_prfls
2807: WHERE cust_account_id = p_cust_account_id;
2808:
2809: CURSOR line_tolerance_party_csr (p_party_id NUMBER)IS
2810: SELECT line_tolerance_operand,

Line 2812: FROM ozf_cust_trd_prfls

2808:
2809: CURSOR line_tolerance_party_csr (p_party_id NUMBER)IS
2810: SELECT line_tolerance_operand,
2811: line_tolerance_calc_code
2812: FROM ozf_cust_trd_prfls
2813: WHERE party_id = p_party_id
2814: AND cust_account_id IS NULL;
2815:
2816: l_batch_org_id NUMBER;