APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CI_TYPES_B

Line 556: pa_ci_types_b pctb

552: CURSOR get_ci_info
553: IS
554: select pci.status_code,
555: pctb.ci_type_class_code from pa_control_items pci,
556: pa_ci_types_b pctb
557: where pci.ci_type_id = pctb.ci_type_id
558: AND pci.ci_id = p_ci_id;
559:
560: /*

Line 643: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

639: l_context VARCHAR2(30);
640:
641:
642: l_status_code pa_control_items.status_code%TYPE;
643: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
644: l_ret VARCHAR2(1);
645: l_ret2 VARCHAR2(1);
646:
647:

Line 652: pa_ci_types_b pctb

648: CURSOR get_ci_info
649: IS
650: select pci.status_code,
651: pctb.ci_type_class_code from pa_control_items pci,
652: pa_ci_types_b pctb
653: where pci.ci_type_id = pctb.ci_type_id
654: AND pci.ci_id = p_ci_id;
655:
656: BEGIN

Line 691: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

687: l_context VARCHAR2(30);
688:
689:
690: l_status_code pa_control_items.status_code%TYPE;
691: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
692: l_ret VARCHAR2(1);
693: l_ret2 VARCHAR2(1);
694:
695:

Line 700: pa_ci_types_b pctb

696: CURSOR get_ci_info
697: IS
698: select pci.status_code,
699: pctb.ci_type_class_code from pa_control_items pci,
700: pa_ci_types_b pctb
701: where pci.ci_type_id = pctb.ci_type_id
702: AND pci.ci_id = p_ci_id;
703:
704: BEGIN

Line 748: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

744: l_temp VARCHAR2(10) := 'NONE';
745: l_context VARCHAR2(30);
746:
747: l_status_code pa_control_items.status_code%TYPE;
748: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
749: l_ret VARCHAR2(1);
750: l_ret2 VARCHAR2(1);
751:
752: BEGIN

Line 787: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

783: l_context VARCHAR2(30);
784:
785:
786: l_status_code pa_control_items.status_code%TYPE;
787: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
788: l_ret VARCHAR2(1);
789: l_ret2 VARCHAR2(1);
790:
791: BEGIN