APPS.PA_CI_SECURITY_PKG dependencies on PA_PROJECT_STATUSES

Line 209: pa_project_statuses s

205:
206: SELECT s.project_system_status_code, ci.owner_id, ci.created_by
207: INTO l_status_code, l_owner_party_id, l_creator_user_id
208: FROM pa_control_items ci,
209: pa_project_statuses s
210: WHERE ci.ci_id = p_ci_id
211: AND s.status_type = 'CONTROL_ITEM'
212: AND s.project_status_code = ci.status_code;
213:

Line 235: pa_project_statuses s

231: BEGIN
232: SELECT ci.project_id, s.project_system_status_code
233: INTO l_project_id, l_status_code
234: FROM pa_control_items ci,
235: pa_project_statuses s
236: WHERE ci.ci_id = p_ci_id
237: AND s.status_type = 'CONTROL_ITEM'
238: AND s.project_status_code = ci.status_code;
239:

Line 343: pa_project_statuses s

339: BEGIN
340: SELECT 1
341: INTO l_tmp
342: FROM pa_ci_actions a,
343: pa_project_statuses s
344: WHERE a.ci_id = p_ci_id
345: AND s.project_status_code = a.status_code
346: AND s.status_type = 'CI_ACTION'
347: AND s.project_system_status_code = 'CI_ACTION_OPEN'

Line 404: pa_project_statuses s

400: BEGIN
401: SELECT 1
402: INTO l_tmp
403: FROM pa_ci_actions a,
404: pa_project_statuses s
405: WHERE a.ci_id = p_ci_id
406: AND s.project_status_code = a.status_code
407: AND s.status_type = 'CI_ACTION'
408: AND s.project_system_status_code = 'CI_ACTION_OPEN'

Line 518: pa_project_statuses s

514:
515: Cursor person_with_open_action is
516: select a.ci_action_id
517: from pa_ci_actions a,
518: pa_project_statuses s
519: where a.assigned_to = l_party_id
520: and a.ci_id = p_ci_id
521: and s.project_status_code = a.status_code
522: AND s.status_type = 'CI_ACTION'

Line 614: pa_project_statuses s

610:
611: Cursor comment_or_close_action is
612: select 'T'
613: from pa_ci_actions a,
614: pa_project_statuses s
615: where a.ci_action_id = p_ci_action_id
616: and a.assigned_to = l_party_id
617: and s.project_status_code = a.status_code
618: AND s.status_type = 'CI_ACTION'