APPS.AR_ADJVALIDATE_PVT dependencies on AR_LOOKUPS

Line 26: lookup_code ar_lookups.lookup_code%type

22: );
23:
24: TYPE Lookup_Rec_Type IS RECORD
25: (
26: lookup_code ar_lookups.lookup_code%type
27: ) ;
28: TYPE Approval_Cache_Tbl_type IS
29: TABLE OF Lookup_Rec_Type
30: INDEX BY BINARY_INTEGER;

Line 105: CURSOR l_lookup_csr (l_lookup_type IN AR_LOOKUPS.LOOKUP_TYPE%TYPE) IS

101: by parameterizing the lookup_type affects : Cache_Approval_Type,
102: Cache_Adjustment_Type and Cache_Adjustment_Reason
103: */
104:
105: CURSOR l_lookup_csr (l_lookup_type IN AR_LOOKUPS.LOOKUP_TYPE%TYPE) IS
106: SELECT lookup_code
107: FROM ar_lookups
108: WHERE lookup_type = l_lookup_type
109: AND enabled_flag = 'Y'

Line 107: FROM ar_lookups

103: */
104:
105: CURSOR l_lookup_csr (l_lookup_type IN AR_LOOKUPS.LOOKUP_TYPE%TYPE) IS
106: SELECT lookup_code
107: FROM ar_lookups
108: WHERE lookup_type = l_lookup_type
109: AND enabled_flag = 'Y'
110: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
111: trunc(sysdate))

Line 852: | - ar_lookups for type = APPROVAL_TYPE |

848: | be accessed later and need not be fetched from the database |
849: | for future transactions. |
850: | |
851: | The following tables are cached |
852: | - ar_lookups for type = APPROVAL_TYPE |
853: | - ar_lookups for type = ADJUSTMENT_TYPE |
854: | - ar_lookups for type = ADJUSTMENT_REASON |
855: | - ussgl transaction codes |
856: | - receivables trx for type = 'ADJUST' |

Line 853: | - ar_lookups for type = ADJUSTMENT_TYPE |

849: | for future transactions. |
850: | |
851: | The following tables are cached |
852: | - ar_lookups for type = APPROVAL_TYPE |
853: | - ar_lookups for type = ADJUSTMENT_TYPE |
854: | - ar_lookups for type = ADJUSTMENT_REASON |
855: | - ussgl transaction codes |
856: | - receivables trx for type = 'ADJUST' |
857: | - code combination ids |

Line 854: | - ar_lookups for type = ADJUSTMENT_REASON |

850: | |
851: | The following tables are cached |
852: | - ar_lookups for type = APPROVAL_TYPE |
853: | - ar_lookups for type = ADJUSTMENT_TYPE |
854: | - ar_lookups for type = ADJUSTMENT_REASON |
855: | - ussgl transaction codes |
856: | - receivables trx for type = 'ADJUST' |
857: | - code combination ids |
858: | - gl periods |