DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_RGM_PARTIES

Line 473: FROM jai_rgm_parties rgmpt,

469: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
470: )
471: IS
472: SELECT 1
473: FROM jai_rgm_parties rgmpt,
474: JAI_RGM_DEFINITIONS rgms
475: WHERE rgmpt.regime_id = rgms.regime_id
476: AND rgmpt.location_id = cp_location_id
477: AND rgmpt.organization_id = cp_organization_id

Line 938: || jai_rgm_parties (Regime Organization Registration)

934:
935: IF nvl(ln_cnt_org_loc_setup,0) = 0 THEN
936: /*
937: || For vat regime organization-location specific setup does not exist in
938: || jai_rgm_parties (Regime Organization Registration)
939: */
940: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'
941: ,EXCEPTION_CODE => NULL
942: ,EXCEPTION_TEXT => 'Organization-Location setup does not exist at regime level'