DBA Data[Home] [Help]

APPS.GMF_VALIDATE_ACCOUNT dependencies on GL_ACCU_MAP

Line 276: # Modified cursors query to go against gl_accu_map table to get the

272: #
273: # HISTORY
274: # 10-Jun-2002 Uday Moogala Bug 2468906 - Created.
275: # 14-Nov-2002 Uday Moogala Bug xxx
276: # Modified cursors query to go against gl_accu_map table to get the
277: # acctg_unit_id/no. Also passing acctg_unit_no to validate procedure
278: # to avoid call to get_accu_no function.
279: # 05-Aug-2003 Venkat Chukkapalli Bug 3080232
280: # Added additional parameter p_acct_no to the procedure.

Line 296: FROM gl_accu_mst mst, gl_accu_map map

292:
293: CURSOR acctg_unit (p_co_code gl_accu_mst.co_code%TYPE)
294: IS
295: SELECT DISTINCT mst.acctg_unit_id, mst.acctg_unit_no -- Bug xxx
296: FROM gl_accu_mst mst, gl_accu_map map
297: WHERE mst.acctg_unit_id = map.acctg_unit_id
298: AND map.co_code = p_co_code
299: AND map.delete_mark = 0
300: AND mst.delete_mark = 0 ;