DBA Data[Home] [Help]

APPS.PQH_CPD_BUS dependencies on PER_SHARED_TYPES

Line 480: FROM per_shared_types_vl

476: l_value varchar2(1000);
477: CURSOR csr_type_of_ps
478: IS
479: SELECT NULL
480: FROM per_shared_types_vl
481: WHERE shared_type_id = TO_NUMBER (p_type_of_ps);
482: BEGIN
483: IF g_debug
484: THEN

Line 525: FROM per_shared_types

521: Procedure chk_primary_prof_field_id(p_primary_prof_field_id IN NUMBER) IS
522:
523: CURSOR csr_primary_prof_field IS
524: SELECT 'Y'
525: FROM per_shared_types
526: WHERE shared_type_id = p_primary_prof_field_id;
527: l_proc Varchar2(72);
528: l_valid Varchar2(1) := 'N';
529: begin