APPS.VEA_PACKAGES_SV dependencies on ALL_SOURCE

Line 1020: from all_source

1016: begin
1017: --
1018: select SUBSTRB(text, INSTRB(text, ' ',1,3) + 1 , INSTRB(text, ' ',1,4) - INSTRB(text, ' ',1,3))
1019: into l_version_text
1020: from all_source
1021: where name = pkg_rec.name
1022: and type ='PACKAGE'
1023: and owner = UPPER(p_user_name)
1024: and text like '%$Head%';

Line 1209: from all_source

1205: begin
1206: --
1207: select SUBSTRB(text, INSTRB(text, ' ',1,3) + 1 , INSTRB(text, ' ',1,4) - INSTRB(text, ' ',1,3))
1208: into l_version_text
1209: from all_source
1210: where name = pkg_rec.name
1211: and type ='PACKAGE'
1212: and owner = UPPER(p_user_name)
1213: and text like '%$Head%';