APPS.AR_ADJVALIDATE_PUB dependencies on AR_LOOKUPS

Line 25: lookup_code ar_lookups.lookup_code%type

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

Line 391: FROM ar_lookups

387: IS
388:
389: CURSOR l_lookup_csr IS
390: SELECT lookup_code
391: FROM ar_lookups
392: WHERE lookup_type = 'APPROVAL_TYPE'
393: AND enabled_flag = 'Y'
394: AND sysdate BETWEEN nvl(start_date_active,sysdate)
395: AND nvl(end_date_active,sysdate) ;

Line 476: FROM ar_lookups

472: IS
473:
474: CURSOR l_lookup_csr IS
475: SELECT lookup_code
476: FROM ar_lookups
477: WHERE lookup_type = 'ADJUSTMENT_TYPE'
478: AND enabled_flag = 'Y'
479: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
480: trunc(sysdate))

Line 562: FROM ar_lookups

558: IS
559:
560: CURSOR l_lookup_csr IS
561: SELECT lookup_code
562: FROM ar_lookups
563: WHERE lookup_type = 'ADJUST_REASON'
564: AND enabled_flag = 'Y'
565: AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
566: trunc(sysdate))

Line 915: | - ar_lookups for type = APPROVAL_TYPE |

911: | be accessed later and need not be fetched from the database |
912: | for future transactions. |
913: | |
914: | The following tables are cached |
915: | - ar_lookups for type = APPROVAL_TYPE |
916: | - ar_lookups for type = ADJUSTMENT_TYPE |
917: | - ar_lookups for type = ADJUSTMENT_REASON |
918: | - ussgl transaction codes |
919: | - receivables trx for type = 'ADJUST' |

Line 916: | - ar_lookups for type = ADJUSTMENT_TYPE |

912: | for future transactions. |
913: | |
914: | The following tables are cached |
915: | - ar_lookups for type = APPROVAL_TYPE |
916: | - ar_lookups for type = ADJUSTMENT_TYPE |
917: | - ar_lookups for type = ADJUSTMENT_REASON |
918: | - ussgl transaction codes |
919: | - receivables trx for type = 'ADJUST' |
920: | - code combination ids |

Line 917: | - ar_lookups for type = ADJUSTMENT_REASON |

913: | |
914: | The following tables are cached |
915: | - ar_lookups for type = APPROVAL_TYPE |
916: | - ar_lookups for type = ADJUSTMENT_TYPE |
917: | - ar_lookups for type = ADJUSTMENT_REASON |
918: | - ussgl transaction codes |
919: | - receivables trx for type = 'ADJUST' |
920: | - code combination ids |
921: | - gl periods |