APPS.PO_CORE_S3 dependencies on PON_UMBRELLA_PROGRAMS
Line 157: l_umb_prog_name PON_UMBRELLA_PROGRAMS.UMBRELLA_PROGRAM_NAME %TYPE;
153: IS
154: --
155: -- This function would return Umbrella Prog Name for the umb_prog_id passed.
156: -- 157: l_umb_prog_name PON_UMBRELLA_PROGRAMS.UMBRELLA_PROGRAM_NAME %TYPE; 158: l_progress VARCHAR2(3) := NULL;
159: BEGIN
160:
161: SELECT umbrella_program_name
Line 163: FROM PON_UMBRELLA_PROGRAMS pup
159: BEGIN
160:
161: SELECT umbrella_program_name
162: INTO l_umb_prog_name 163: FROM PON_UMBRELLA_PROGRAMS pup 164: WHERE pup.umbrella_program_id = p_umb_prog_id;
165:
166: l_progress := '010';
167: