APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_LOOKUPS

Line 94: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS

90: SELECT name
91: FROM ar_receivables_trx
92: WHERE receivables_trx_id = cv_settlement_type_id;
93:
94: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
95: SELECT meaning
96: FROM ozf_lookups
97: WHERE lookup_type = 'OZF_CUSTOMIZED_OBJECT_CLASS'
98: AND lookup_code = cv_payment_method;

Line 96: FROM ozf_lookups

92: WHERE receivables_trx_id = cv_settlement_type_id;
93:
94: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
95: SELECT meaning
96: FROM ozf_lookups
97: WHERE lookup_type = 'OZF_CUSTOMIZED_OBJECT_CLASS'
98: AND lookup_code = cv_payment_method;
99:
100: l_claim_class VARCHAR2(30);

Line 160: OPEN csr_ozf_lookups_trx (p_payment_method);

156: FETCH csr_ar_receivables_trx INTO x_settlement_type;
157: CLOSE csr_ar_receivables_trx;
158: END IF;
159: ELSE
160: OPEN csr_ozf_lookups_trx (p_payment_method);
161: FETCH csr_ozf_lookups_trx INTO x_settlement_type;
162: CLOSE csr_ozf_lookups_trx;
163:
164: END IF;

Line 161: FETCH csr_ozf_lookups_trx INTO x_settlement_type;

157: CLOSE csr_ar_receivables_trx;
158: END IF;
159: ELSE
160: OPEN csr_ozf_lookups_trx (p_payment_method);
161: FETCH csr_ozf_lookups_trx INTO x_settlement_type;
162: CLOSE csr_ozf_lookups_trx;
163:
164: END IF;
165:

Line 162: CLOSE csr_ozf_lookups_trx;

158: END IF;
159: ELSE
160: OPEN csr_ozf_lookups_trx (p_payment_method);
161: FETCH csr_ozf_lookups_trx INTO x_settlement_type;
162: CLOSE csr_ozf_lookups_trx;
163:
164: END IF;
165:
166: END IF;

Line 438: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS

434: SELECT name
435: FROM ar_receivables_trx
436: WHERE receivables_trx_id = cv_settlement_type_id;
437:
438: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
439: SELECT meaning
440: FROM ozf_lookups
441: WHERE lookup_type = 'OZF_CUSTOMIZED_OBJECT_CLASS'
442: AND lookup_code = cv_payment_method;

Line 440: FROM ozf_lookups

436: WHERE receivables_trx_id = cv_settlement_type_id;
437:
438: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
439: SELECT meaning
440: FROM ozf_lookups
441: WHERE lookup_type = 'OZF_CUSTOMIZED_OBJECT_CLASS'
442: AND lookup_code = cv_payment_method;
443:
444: l_claim_class VARCHAR2(30);

Line 1674: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS

1670: SELECT name
1671: FROM ar_receivables_trx
1672: WHERE receivables_trx_id = cv_settlement_type_id;
1673:
1674: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
1675: SELECT meaning
1676: FROM ozf_lookups
1677: WHERE lookup_type = 'OZF_CUSTOMIZED_OBJECT_CLASS'
1678: AND lookup_code = cv_payment_method;

Line 1676: FROM ozf_lookups

1672: WHERE receivables_trx_id = cv_settlement_type_id;
1673:
1674: CURSOR csr_ozf_lookups_trx(cv_payment_method IN VARCHAR2) IS
1675: SELECT meaning
1676: FROM ozf_lookups
1677: WHERE lookup_type = 'OZF_CUSTOMIZED_OBJECT_CLASS'
1678: AND lookup_code = cv_payment_method;
1679:
1680: l_claim_class VARCHAR2(30);

Line 5098: FROM OZF_LOOKUPS

5094:
5095:
5096: CURSOR csr_claim_class_name(p_lkup_code IN VARCHAR2) IS
5097: SELECT MEANING
5098: FROM OZF_LOOKUPS
5099: WHERE lookup_type= 'OZF_CLAIM_CLASS'
5100: AND lookup_code = p_lkup_code;
5101:
5102: CURSOR csr_settlement_method_name(p_lkup_code IN VARCHAR2) IS

Line 5104: FROM OZF_LOOKUPS

5100: AND lookup_code = p_lkup_code;
5101:
5102: CURSOR csr_settlement_method_name(p_lkup_code IN VARCHAR2) IS
5103: SELECT MEANING
5104: FROM OZF_LOOKUPS
5105: WHERE lookup_type= 'OZF_PAYMENT_METHOD'
5106: AND lookup_code = p_lkup_code;
5107:
5108: CURSOR csr_customer_name(p_cust_act_id IN NUMBER) IS