APPS.PA_CI_SECURITY_PKG dependencies on PA_CI_TYPES_B

Line 22: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;

18: p_user_id NUMBER DEFAULT fnd_global.user_id,
19: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
20: RETURN VARCHAR2
21: IS
22: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;
23: BEGIN
24: IF G_user_id <> p_user_id THEN
25: G_user_id := p_user_id;
26: G_resp_id := p_resp_id;

Line 44: FROM pa_ci_types_b cit,

40: END IF;
41:
42: SELECT ci_type_class_code
43: INTO l_class_code
44: FROM pa_ci_types_b cit,
45: pa_control_items ci
46: WHERE ci.ci_id = p_ci_id
47: AND cit.ci_type_id = ci.ci_type_id;
48:

Line 89: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;

85: p_user_id NUMBER DEFAULT fnd_global.user_id,
86: p_resp_id NUMBER DEFAULT fnd_global.resp_id)
87: RETURN VARCHAR2
88: IS
89: l_class_code pa_ci_types_b.ci_type_class_code%TYPE;
90: BEGIN
91: IF G_user_id <> p_user_id THEN
92: G_user_id := p_user_id;
93: G_resp_id := p_resp_id;

Line 713: FROM pa_ci_types_b

709: END IF;
710:
711: SELECT allow_all_usage_flag
712: INTO l_allow_all_usage_flag
713: FROM pa_ci_types_b
714: WHERE ci_type_id = p_ci_type_id;
715:
716: IF l_allow_all_usage_flag = 'N' THEN
717: BEGIN