DBA Data[Home] [Help]

APPS.JAI_AR_UTILS_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 1621: FROM JAI_RGM_REGISTRATIONS a,

1617: FUNCTION get_tcs_flag RETURN NUMBER
1618: IS
1619: CURSOR cur_get_tcs_flag IS
1620: SELECT COUNT(*)
1621: FROM JAI_RGM_REGISTRATIONS a,
1622: JAI_RGM_DEFINITIONS b
1623: WHERE a.attribute_code = 'AR_RECEIPT_CLASS'
1624: AND a.registration_type = 'OTHERS'
1625: AND a.attribute_type_code = 'OTHERS'

Line 1646: FROM JAI_RGM_REGISTRATIONS a,

1642: FROM ar_receipt_classes a,
1643: ar_receipt_methods b
1644: WHERE a.receipt_class_id = b.receipt_class_id
1645: AND a.name IN(SELECT a.attribute_value receipt_class
1646: FROM JAI_RGM_REGISTRATIONS a,
1647: JAI_RGM_DEFINITIONS b
1648: WHERE a.attribute_code = 'AR_RECEIPT_CLASS'
1649: AND a.registration_type = 'OTHERS'
1650: AND a.attribute_type_code = 'OTHERS'