APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_RGM_DEFINITIONS

Line 38: FROM jai_rgm_definitions

34: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS
35: select to_date(attribute_value, 'DD/MM/YYYY')
36: from JAI_RGM_ORG_REGNS_V
37: where regime_id IN (SELECT regime_id
38: FROM jai_rgm_definitions
39: WHERE regime_code = jai_constants.service_regime
40: )
41: and organization_id = p_organization_id
42: and location_id = p_location_id

Line 50: FROM jai_rgm_definitions

46: AND (NOT EXISTS
47: (select '1'
48: from JAI_RGM_ORG_REGNS_V
49: where regime_id IN (SELECT regime_id
50: FROM jai_rgm_definitions
51: WHERE regime_code = jai_constants.service_regime
52: )
53: and attribute_code IN 'INV_ORG_CLASSIFICATION'
54: and attribute_value <> 'ORGANIZATION'

Line 62: FROM jai_rgm_definitions

58: NOT EXISTS
59: (select '1'
60: from JAI_RGM_ORG_REGNS_V
61: where regime_id IN (SELECT regime_id
62: FROM jai_rgm_definitions
63: WHERE regime_code = jai_constants.service_regime
64: )
65: and attribute_code IN 'SERVICE TYPE'
66: and attribute_value <> 'OTHER'

Line 73: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

69: );
70:
71: CURSOR c_ap_reversal_unit IS
72: SELECT jrr.attribute_value
73: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
74: WHERE jrr.regime_id = jrd.regime_id
75: AND jrd.regime_code = 'SERVICE'
76: AND jrr.attribute_code = 'REVERSAL_AP_UNIT'
77: AND jrr.registration_type = 'OTHERS';

Line 81: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

77: AND jrr.registration_type = 'OTHERS';
78:
79: CURSOR c_ar_reversal_unit IS
80: SELECT jrr.attribute_value
81: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
82: WHERE jrr.regime_id = jrd.regime_id
83: AND jrd.regime_code = 'SERVICE'
84: AND jrr.attribute_code = 'REVERSAL_AR_UNIT'
85: AND jrr.registration_type = 'OTHERS';

Line 89: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

85: AND jrr.registration_type = 'OTHERS';
86:
87: CURSOR c_ap_reversal_num IS
88: SELECT jrr.attribute_value
89: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
90: WHERE jrr.regime_id = jrd.regime_id
91: AND jrd.regime_code = 'SERVICE'
92: AND jrr.attribute_code = 'REVERSAL_AP_NUM'
93: AND jrr.registration_type = 'OTHERS';

Line 97: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

93: AND jrr.registration_type = 'OTHERS';
94:
95: CURSOR c_ar_reversal_num IS
96: SELECT jrr.attribute_value
97: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
98: WHERE jrr.regime_id = jrd.regime_id
99: AND jrd.regime_code = 'SERVICE'
100: AND jrr.attribute_code = 'REVERSAL_AR_NUM'
101: AND jrr.registration_type = 'OTHERS';

Line 941: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

937: END is_paid_after_reversal;
938: FUNCTION get_reversal_date(pd_gl_date DATE, pv_source VARCHAR2) RETURN DATE IS
939: CURSOR c_ap_reversal_unit IS
940: SELECT jrr.attribute_value
941: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
942: WHERE jrr.regime_id = jrd.regime_id
943: AND jrd.regime_code = 'SERVICE'
944: AND jrr.attribute_code = 'REVERSAL_AP_UNIT'
945: AND jrr.registration_type = 'OTHERS';

Line 949: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

945: AND jrr.registration_type = 'OTHERS';
946:
947: CURSOR c_ar_reversal_unit IS
948: SELECT jrr.attribute_value
949: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
950: WHERE jrr.regime_id = jrd.regime_id
951: AND jrd.regime_code = 'SERVICE'
952: AND jrr.attribute_code = 'REVERSAL_AR_UNIT'
953: AND jrr.registration_type = 'OTHERS';

Line 957: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

953: AND jrr.registration_type = 'OTHERS';
954:
955: CURSOR c_ap_reversal_num IS
956: SELECT jrr.attribute_value
957: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
958: WHERE jrr.regime_id = jrd.regime_id
959: AND jrd.regime_code = 'SERVICE'
960: AND jrr.attribute_code = 'REVERSAL_AP_NUM'
961: AND jrr.registration_type = 'OTHERS';

Line 965: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd

961: AND jrr.registration_type = 'OTHERS';
962:
963: CURSOR c_ar_reversal_num IS
964: SELECT jrr.attribute_value
965: FROM jai_rgm_registrations jrr, jai_rgm_definitions jrd
966: WHERE jrr.regime_id = jrd.regime_id
967: AND jrd.regime_code = 'SERVICE'
968: AND jrr.attribute_code = 'REVERSAL_AR_NUM'
969: AND jrr.registration_type = 'OTHERS';