APPS.PA_CI_SECURITY_PKG dependencies on PA_CI_ACTIONS

Line 253: FROM pa_ci_actions a

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

Line 295: FROM pa_ci_actions a

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

Line 342: FROM pa_ci_actions a,

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

Line 403: FROM pa_ci_actions a,

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

Line 517: from pa_ci_actions a,

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

Line 613: from pa_ci_actions a,

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