929: l_process_type varchar2(50);
930: l_measure_type varchar2(50);
931: cursor getprstype(l_prcCodeIn in varchar2) is
932: select meaning
933: from hr_lookups
934: where lookup_type = 'IRC_PROCESS_TYPE'
935: and lookup_code = l_prcCodeIn;
936:
937: cursor getmeasureType(l_msrCodeIn in varchar2) is
935: and lookup_code = l_prcCodeIn;
936:
937: cursor getmeasureType(l_msrCodeIn in varchar2) is
938: select meaning
939: from hr_lookups
940: where lookup_type = 'IRC_MEASURE_TYPE'
941: and lookup_code = l_msrCodeIn;
942: begin
943: --