DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on CSM_DEBRIEF_HEADERS_ACC

Line 1863: FROM csm_debrief_headers_acc acc

1859: CURSOR l_debrief_hdr_csr(p_debrief_header_id IN NUMBER )
1860: IS
1861: SELECT acc.debrief_header_id,
1862: acc.user_id
1863: FROM csm_debrief_headers_acc acc
1864: WHERE acc.debrief_header_id = p_debrief_header_id;
1865:
1866: BEGIN
1867: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1918: csm_debrief_headers_acc acc

1914: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
1915: IS
1916: SELECT dhdr.debrief_header_id, acc.user_id
1917: FROM csf_debrief_headers dhdr,
1918: csm_debrief_headers_acc acc
1919: WHERE dhdr.debrief_header_id = p_debrief_header_id
1920: AND acc.debrief_header_id = dhdr.debrief_header_id;
1921:
1922: l_csm_debrfHdDel_rec l_csm_debrfHdDel_csr%ROWTYPE;