APPS.PQH_RANK_UTILITY dependencies on BEN_PGM_EXTRA_INFO

Line 406: ,ben_pgm_extra_info pgmei

402: begin
403: select 'Y'
404: into l_present_flag
405: from ben_pgm_f pgm
406: ,ben_pgm_extra_info pgmei
407: where pgm.business_group_id = p_business_group_id
408: and pgm.pgm_id = pgmei.pgm_id
409: and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
410: and pgmei.pgi_information2 = 'Y' -- Verify and confirm

Line 440: from ben_pgm_extra_info pgmei

436: begin
437: --NS 4/23/05: If not set, treat it as not found
438: select NVL(pgi_information1,'NOT_FOUND') -- Verify and confirm
439: into l_option_value
440: from ben_pgm_extra_info pgmei
441: where pgmei.pgm_id = p_pgm_id
442: and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
443: and rownum < 2 ;
444: exception

Line 454: from ben_pgm_extra_info pgmei

450: begin
451: --NS 4/23/05: If not set, treat it as N
452: select NVL(pgi_information2,'N') -- Verify and confirm
453: into l_option_value
454: from ben_pgm_extra_info pgmei
455: where pgmei.pgm_id = p_pgm_id
456: and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
457: and rownum < 2 ;
458: exception

Line 467: from ben_pgm_extra_info pgmei

463: begin
464: --NS 4/23/05: If not set, treat it as not found
465: select NVL(pgi_information3,'NOT_FOUND') -- Verify and confirm
466: into l_option_value
467: from ben_pgm_extra_info pgmei
468: where pgmei.pgm_id = p_pgm_id
469: and pgmei.information_type = 'PQH_GSP_EXTRA_INFO'
470: and rownum < 2 ;
471: exception