[Home] [Help]
5009:
5010: -- to get Organization related to TAN
5011: CURSOR c_organization_id(p_tan_number IN VARCHAR2, p_organization_id IN NUMBER DEFAULT NULL) IS
5012: SELECT organization_id
5013: FROM jai_ap_tds_org_tan_v --- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
5014: WHERE org_tan_num = p_tan_number
5015: AND organization_id = nvl(p_organization_id, organization_id);
5016: /*ETDS FVU3.1 Bug 11896260 start*/
5017: --to get organisation_id from tan
6223:
6224:
6225: 6. 2/05/2005 rchandan for bug#4323338. Version 116.1
6226: India Org Info DFF is eliminated as a part of JA migration. A table by name ja_in_ap_tds_org_tan is dropped
6227: and a view jai_ap_tds_org_tan_v is created to capture the PAN No,TAN NO and WARD NO. The code changes are done
6228: to refer to the new view instead of the dropped table.
6229:
6230: 7. 8/05/2005 rchandan for bug#4333488. Version 116.1
6231: The Invoice Distribution DFF is eliminated and a new global DFF is used to
6390: jai_rgm_registrations jrr
6391: where jrd.regime_code = 'TDS'
6392: and jrd.regime_id = jrp.regime_id
6393: and jrp.regime_org_id = jrpr.regime_org_id
6394: and jrp.organization_id in (select distinct organization_id from jai_ap_tds_org_tan_v where org_tan_num = p_tan_number)
6395: and jrr.registration_id = jrpr.registration_id;
6396:
6397: if (v_regime_override > 0) then
6398: FND_FILE.put_line(FND_FILE.log, 'Regime setup is not same for all OUs for the provided TAN number');