DBA Data[Home] [Help]

APPS.GMI_MSCA_PUB dependencies on SY_ORGN_MST

Line 219: FROM sy_orgn_mst m, sy_orgn_usr u

215: BEGIN
216:
217: OPEN x_orgn_cursor FOR
218: SELECT m.orgn_code, m.orgn_name, m.co_code
219: FROM sy_orgn_mst m, sy_orgn_usr u
220: WHERE u.user_id = p_user_id
221: AND u.orgn_code = m.orgn_code
222: AND m.orgn_code like p_orgn
223: AND m.delete_mark = 0