APPS.PA_CI_SECURITY_PKG dependencies on PA_CI_ACTIONS

Line 255: FROM pa_ci_actions a

251: --Allowing view access if user ever has an action
252: BEGIN
253: SELECT 1
254: INTO l_tmp
255: FROM pa_ci_actions a
256: WHERE a.ci_id = p_ci_id
257: AND a.assigned_to = G_party_id
258: AND ROWNUM = 1;
259: EXCEPTION

Line 297: FROM pa_ci_actions a

293: --Allowing view access if user ever has an action
294: BEGIN
295: SELECT 1
296: INTO l_tmp
297: FROM pa_ci_actions a
298: WHERE a.ci_id = p_ci_id
299: AND a.assigned_to = G_party_id
300: AND ROWNUM = 1;
301: EXCEPTION

Line 357: FROM pa_ci_actions a,

353: --People w/ an open Update action can update the item
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'

Line 418: FROM pa_ci_actions a,

414: --People w/ an open Update action can update the item
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'

Line 534: from pa_ci_actions a,

530: l_project_org_id NUMBER;
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

Line 630: from pa_ci_actions a,

626: l_party_id number;
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