APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 2148: FROM JAI_RGM_ORG_REGNS_V

2144: from JAI_AP_TDS_YEARS
2145: where tan_no in \* where clause and subquery added by ssumaith - bug# 4448789*\
2146: (
2147: SELECT attribute_value
2148: FROM JAI_RGM_ORG_REGNS_V
2149: WHERE regime_code = lv_tds_regime
2150: AND registration_type = lv_regn_type_others
2151: AND attribute_type_code = lv_attr_type_Code
2152: AND attribute_code = lv_attr_code

Line 2616: FROM JAI_RGM_ORG_REGNS_V

2612: where period_set_id
2613: in
2614: (
2615: SELECT attribute_value
2616: FROM JAI_RGM_ORG_REGNS_V
2617: WHERE regime_code = lv_tds_regime--'TDS'
2618: AND registration_type = lv_regn_type_others--'OTHERS'
2619: AND attribute_type_code = lv_attr_type_Code--'OTHERS'
2620: AND attribute_code = lv_attr_code--'TDS_CALENDAR'

Line 2636: FROM JAI_RGM_ORG_REGNS_V

2632: from JAI_AP_TDS_YEARS
2633: where tan_no in \* where clause and subquery added by ssumaith - bug# 4448789*\
2634: (
2635: SELECT attribute_value
2636: FROM JAI_RGM_ORG_REGNS_V
2637: WHERE regime_code = lv_tds_regime
2638: AND registration_type = lv_regn_type_others
2639: AND attribute_type_code = lv_attr_type_Code
2640: AND attribute_code = lv_attr_code

Line 3068: FROM JAI_RGM_ORG_REGNS_V

3064:
3065: CURSOR get_default_from_rgm(cn_org_id number)
3066: is
3067: SELECT attribute_value
3068: FROM JAI_RGM_ORG_REGNS_V
3069: WHERE regime_code = 'TDS'
3070: AND registration_type = 'OTHERS'
3071: AND attribute_type_code = 'OTHERS'
3072: AND attribute_code = 'TDS_DEFAULTATION'

Line 3160: lv_default_option JAI_RGM_ORG_REGNS_V.attribute_value%type;

3156: ln_section_diff number;
3157: ------------------------------------------------------------
3158: --Added by Zhiwei Hou for Bug#13818183 on 20120308 end
3159:
3160: lv_default_option JAI_RGM_ORG_REGNS_V.attribute_value%type;
3161: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%type;
3162: lv_natural_account JAI_DTC_SCTN_ACCOUNT_MAPPING.natural_account_value%type;
3163: lv_prospective_flag varchar2(1);
3164: ln_hdr_id number;