APPS.PQH_STS_BUS dependencies on HR_LOOKUPS

Line 392: from hr_lookups

388: l_value varchar2(100);
389: --
390: Cursor csr_frequency IS
391: Select null
392: from hr_lookups
393: Where Lookup_type='PROC_PERIOD_TYPE'
394: and ENABLED_FLAG='Y'
395: and lookup_code = p_frequency;
396: --

Line 481: from hr_lookups

477: --
478:
479: Cursor csr_reason IS
480: Select null
481: from hr_lookups
482: where lookup_type ='FR_PQH_STAT_SIT_REASON'
483: and lookup_code like p_situation_type || '%'
484: and lookup_code = p_reason
485: and enabled_flag = 'Y';

Line 520: from hr_lookups

516: l_value varchar2(100);
517: --
518: Cursor csr_location IS
519: Select null
520: from hr_lookups
521: Where Lookup_type='FR_PQH_STAT_SIT_PLCMENT'
522: and ENABLED_FLAG='Y'
523: and lookup_code = p_location;
524:

Line 561: from hr_lookups

557: l_value varchar2(100);
558: --
559: Cursor csr_source IS
560: Select null
561: from hr_lookups
562: Where Lookup_type='FR_PQH_STAT_SIT_SOURCE'
563: and ENABLED_FLAG='Y'
564: and lookup_code = p_source;
565:

Line 601: from hr_lookups

597: l_value varchar2(100);
598: --
599: Cursor csr_sub_type IS
600: Select null
601: from hr_lookups
602: where lookup_type ='FR_PQH_STAT_SIT_SUB_TYPE'
603: and lookup_code like p_situation_type || '%'
604: and lookup_code = p_sub_type
605: and enabled_flag = 'Y';

Line 956: from hr_lookups

952: l_value varchar2(1000);
953: --
954: Cursor csr_situation_type IS
955: Select null
956: from hr_lookups
957: Where Lookup_type='FR_PQH_STAT_SIT_TYPE'
958: and ENABLED_FLAG='Y'
959: and lookup_code =p_situation_type;
960: --