DBA Data[Home] [Help]

APPS.CSM_USER_EVENT_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 554: FROM csp_requirement_headers hdr,

550: IS
551: SELECT hdr.requirement_header_id,
552: au.resource_id,
553: au.user_id
554: FROM csp_requirement_headers hdr,
555: asg_user au
556: WHERE hdr.resource_id = au.resource_id
557: AND au.resource_id = p_resource_id
558: AND NOT EXISTS

Line 603: FROM csp_requirement_headers hdr,

599: SELECT hdr.requirement_header_id,
600: hdr.resource_id,
601: line.requirement_line_id,
602: au.user_id
603: FROM csp_requirement_headers hdr,
604: csp_requirement_lines line,
605: asg_user au
606: WHERE hdr.requirement_header_id = line.requirement_header_id
607: AND hdr.resource_id = au.resource_id