APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CI_TYPES_B

Line 483: pa_ci_types_b pctb

479: CURSOR get_ci_info
480: IS
481: select pci.status_code,
482: pctb.ci_type_class_code from pa_control_items pci,
483: pa_ci_types_b pctb
484: where pci.ci_type_id = pctb.ci_type_id
485: AND pci.ci_id = p_ci_id;
486:
487: /*

Line 570: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

566: l_context VARCHAR2(30);
567:
568:
569: l_status_code pa_control_items.status_code%TYPE;
570: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
571: l_ret VARCHAR2(1);
572: l_ret2 VARCHAR2(1);
573:
574:

Line 579: pa_ci_types_b pctb

575: CURSOR get_ci_info
576: IS
577: select pci.status_code,
578: pctb.ci_type_class_code from pa_control_items pci,
579: pa_ci_types_b pctb
580: where pci.ci_type_id = pctb.ci_type_id
581: AND pci.ci_id = p_ci_id;
582:
583: BEGIN

Line 618: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

614: l_context VARCHAR2(30);
615:
616:
617: l_status_code pa_control_items.status_code%TYPE;
618: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
619: l_ret VARCHAR2(1);
620: l_ret2 VARCHAR2(1);
621:
622:

Line 627: pa_ci_types_b pctb

623: CURSOR get_ci_info
624: IS
625: select pci.status_code,
626: pctb.ci_type_class_code from pa_control_items pci,
627: pa_ci_types_b pctb
628: where pci.ci_type_id = pctb.ci_type_id
629: AND pci.ci_id = p_ci_id;
630:
631: BEGIN

Line 675: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

671: l_temp VARCHAR2(10) := 'NONE';
672: l_context VARCHAR2(30);
673:
674: l_status_code pa_control_items.status_code%TYPE;
675: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
676: l_ret VARCHAR2(1);
677: l_ret2 VARCHAR2(1);
678:
679: BEGIN

Line 714: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;

710: l_context VARCHAR2(30);
711:
712:
713: l_status_code pa_control_items.status_code%TYPE;
714: l_type_class pa_ci_types_b.ci_type_class_code%TYPE;
715: l_ret VARCHAR2(1);
716: l_ret2 VARCHAR2(1);
717:
718: BEGIN