APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_DEFINITIONS

Line 77: , cp_rgm_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS

73: | cp_trx_date IN DATE YES transaction date |
74: ---------------------------------------------------------------------------------------------------------------------------------*/
75: FUNCTION get_tcs_fin_year(
76: cp_attr_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR
77: , cp_rgm_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS
78: , cp_trx_date DATE
79: ) RETURN VARCHAR2
80: IS
81:

Line 85: FROM JAI_RGM_DEFINITIONS jrd,

81:
82: cursor c_get_tcs_rgm_atrbt
83: is
84: SELECT jrr.ATTRIBUTE_VALUE
85: FROM JAI_RGM_DEFINITIONS jrd,
86: JAI_RGM_REGISTRATIONS jrr
87: WHERE jrd.REGIME_ID = jrr.REGIME_ID
88: AND jrr.ATTRIBUTE_CODE = cp_attr_code
89: AND jrd.REGIME_CODE = cp_rgm_code;

Line 803: cursor c_get_rgm_attribute ( cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type

799: ln_fin_year jai_rgm_thresholds.fin_year%type;
800: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;
801:
802: /** cursor will fetch org_tan_no from regime setup */
803: cursor c_get_rgm_attribute ( cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
804: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%type
805: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_code%type
806: , cp_organization_id jai_rgm_parties.organization_id%type
807: )