DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_RGM_PARTIES

Line 430: FROM jai_rgm_parties rgmpt,

426: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
427: )
428: IS
429: SELECT 1
430: FROM jai_rgm_parties rgmpt,
431: JAI_RGM_DEFINITIONS rgms
432: WHERE rgmpt.regime_id = rgms.regime_id
433: AND rgmpt.location_id = cp_location_id
434: AND rgmpt.organization_id = cp_organization_id

Line 755: || jai_rgm_parties (Regime Organization Registration)

751:
752: IF nvl(ln_cnt_org_loc_setup,0) = 0 THEN
753: /*
754: || For vat regime organization-location specific setup does not exist in
755: || jai_rgm_parties (Regime Organization Registration)
756: */
757: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'
758: ,EXCEPTION_CODE => NULL
759: ,EXCEPTION_TEXT => 'Organization-Location setup does not exist at regime level'