DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 171: Modified the query of the cursor c_pan_number and included the view jai_rgm_org_regns_v instead of the three table names.

167: Added New cursor c_get_tds_inv_det in the populate_details procedure to calculate the surcharge amount at threshold
168: transition when surcharge gets applicable.
169:
170: 30. 08-apr-2010 Bgowrava for Bug#9494515
171: Modified the query of the cursor c_pan_number and included the view jai_rgm_org_regns_v instead of the three table names.
172: This would fetch the correct PAN number for the organization.
173:
174: 31. 25-Oct-2010 Bug 10020606
175: Description: All TDS reports must be based on GL Date or date on which TCS Liability is booked

Line 5041: FROM jai_rgm_org_regns_v

5037: -- to get PAN related to TAN
5038: /*Modified the below cursor by Bgowrava for Bug#9494515*/
5039: CURSOR c_pan_number(p_organization_id IN NUMBER) IS --Harshita for bug#4889272
5040: SELECT attribute_value ORG_TAN_NUM
5041: FROM jai_rgm_org_regns_v
5042: WHERE
5043: regime_code = 'TDS'
5044: AND organization_id = p_organization_id
5045: AND registration_type = lv_oth_reg_type