DBA Data[Home] [Help]

APPS.XNB_UTIL_PVT dependencies on CLN_COLL_HIST_HDR

Line 122: from cln_coll_hist_hdr clnhdr,

118: while (l_tp_codes%FOUND) LOOP
119:
120: select COUNT(clndtl.collaboration_dtl_id)
121: into l_num
122: from cln_coll_hist_hdr clnhdr,
123: cln_coll_hist_dtl clndtl
124: where
125: clnhdr.application_id = 881
126: and clnhdr.collaboration_type = p_collab_type

Line 258: FROM cln_coll_hist_hdr clnhdr,

254:
255: --Check the number of Successful ConfirmBODs sent by the given billing app.
256: SELECT COUNT(clndtl.collaboration_dtl_id)
257: INTO l_num
258: FROM cln_coll_hist_hdr clnhdr,
259: cln_coll_hist_dtl clndtl
260: WHERE
261: clnhdr.application_id = 881
262: AND clnhdr.collaboration_type = p_collab_type