DBA Data[Home] [Help]

APPS.GR_OTHER_NAMES_TL_PKG dependencies on SY_ORGN_MST

Line 426: SY_ORGN_MST S

422: delete from GR_OTHER_NAMES_TL T
423: where not exists
424: (select NULL
425: from GR_ITEM_GENERAL B,
426: SY_ORGN_MST S
427: where B.ITEM_CODE = T.ITEM_CODE
428: and S.ORGN_CODE = T.ORGN_CODE
429: );
430:

Line 971: FROM sy_orgn_mst om

967:
968: CURSOR c_get_orgn
969: IS
970: SELECT om.orgn_code
971: FROM sy_orgn_mst om
972: WHERE orgn_code = p_orgn_code;
973: OrgnRecord c_get_orgn%ROWTYPE;
974:
975: BEGIN

Line 1227: SY_ORGN_MST S

1223: delete from GR_OTHER_NAMES_TL T
1224: where not exists
1225: (select NULL
1226: from GR_ITEM_GENERAL B,
1227: SY_ORGN_MST S
1228: where B.ITEM_CODE = T.ITEM_CODE
1229: and S.ORGN_CODE = T.ORGN_CODE
1230: );
1231: