APPS.PA_CI_SECURITY_PKG dependencies on PA_PROJECT_STATUSES

Line 211: pa_project_statuses s

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

Line 237: pa_project_statuses s

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

Line 358: pa_project_statuses s

354: BEGIN
355: SELECT 1
356: INTO l_tmp
357: FROM pa_ci_actions a,
358: pa_project_statuses s
359: WHERE a.ci_id = p_ci_id
360: AND s.project_status_code = a.status_code
361: AND s.status_type = 'CI_ACTION'
362: AND s.project_system_status_code = 'CI_ACTION_OPEN'

Line 419: pa_project_statuses s

415: BEGIN
416: SELECT 1
417: INTO l_tmp
418: FROM pa_ci_actions a,
419: pa_project_statuses s
420: WHERE a.ci_id = p_ci_id
421: AND s.project_status_code = a.status_code
422: AND s.status_type = 'CI_ACTION'
423: AND s.project_system_status_code = 'CI_ACTION_OPEN'

Line 535: pa_project_statuses s

531:
532: Cursor person_with_open_action is
533: select a.ci_action_id
534: from pa_ci_actions a,
535: pa_project_statuses s
536: where a.assigned_to = l_party_id
537: and a.ci_id = p_ci_id
538: and s.project_status_code = a.status_code
539: AND s.status_type = 'CI_ACTION'

Line 631: pa_project_statuses s

627:
628: Cursor comment_or_close_action is
629: select 'T'
630: from pa_ci_actions a,
631: pa_project_statuses s
632: where a.ci_action_id = p_ci_action_id
633: and a.assigned_to = l_party_id
634: and s.project_status_code = a.status_code
635: AND s.status_type = 'CI_ACTION'