APPS.PA_CI_TYPES_PVT dependencies on PA_CI_TYPES_B

Line 93: SELECT pa_ci_types_b_s.NEXTVAL

89: fnd_msg_pub.add();
90: END IF;
91:
92: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
93: SELECT pa_ci_types_b_s.NEXTVAL
94: INTO x_ci_type_id
95: FROM sys.dual;
96:
97: pa_ci_types_pkg.insert_row(

Line 390: FROM pa_ci_types_b cit,

386: IF p_auto_number_flag = 'Y' THEN
387: BEGIN
388: SELECT 'X'
389: INTO l_temp
390: FROM pa_ci_types_b cit,
391: pa_control_items ci
392: WHERE cit.ci_type_id = p_ci_type_id
393: AND cit.auto_number_flag <> 'Y'
394: AND ci.ci_type_id = p_ci_type_id