APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 18: ( pv_registration_num jai_rgm_registrations.ATTRIBUTE_VALUE%TYPE

14: lv_object_name jai_cmn_debug_contexts.log_context%type default 'jai_st_reversal_extract_pkg';
15: lv_member_name jai_cmn_debug_contexts.log_context%type;
16: lv_context jai_cmn_debug_contexts.log_context%type;
17: procedure extract_reversal_trxs
18: ( pv_registration_num jai_rgm_registrations.ATTRIBUTE_VALUE%TYPE
19: , pn_organization_id NUMBER
20: , pn_location_id NUMBER
21: , pv_source VARCHAR2
22: , pn_vendor_id NUMBER

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';