DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on AR_LOOKUPS

Line 1983: FROM ar_lookups ar

1979: AND lookup_code = cv_status_code;
1980:
1981: CURSOR csr_ar_cm_reason_code(cv_reason_code_id IN NUMBER) IS
1982: SELECT ar.meaning
1983: FROM ar_lookups ar
1984: , ozf_reason_codes_vl rs
1985: WHERE rs.reason_code_id = cv_reason_code_id
1986: AND ar.lookup_type = 'CREDIT_MEMO_REASON'
1987: AND rs.reason_code = ar.lookup_code;

Line 1991: FROM ar_lookups ar

1987: AND rs.reason_code = ar.lookup_code;
1988:
1989: CURSOR csr_ar_adj_reason_code(cv_reason_code_id IN NUMBER) IS
1990: SELECT ar.meaning
1991: FROM ar_lookups ar
1992: , ozf_reason_codes_vl rs
1993: WHERE rs.reason_code_id = cv_reason_code_id
1994: AND ar.lookup_type = 'ADJUST_REASON'
1995: AND rs.adjustment_reason_code = ar.lookup_code;