[Home] [Help]
523: 'OT', 'PAEXPITDFF - OT',
524: 'PAEXPITDFF - ST'
525: )
526: INTO new_att_catg
527: FROM DUAL;
528: ELSE
529: SELECT DECODE (
530: hxc_alias_utility.get_sfl_from_alias_value (new_att_catg),
531: 'OT', 'PAEXPITDFF - OT',
531: 'OT', 'PAEXPITDFF - OT',
532: 'PAEXPITDFF - ST'
533: )
534: INTO new_att_catg
535: FROM DUAL;
536: END IF;
537: ELSIF l_reference_field = 'EXPENDITURE_TYPE' THEN
538: IF p_att_tab (att_dep_item).alias_type LIKE 'VALUE%' THEN
539: SELECT hxc_deposit_wrapper_utilities.get_dupdff_code (
539: SELECT hxc_deposit_wrapper_utilities.get_dupdff_code (
540: 'PAEXPITDFF - '|| SUBSTR (new_att_catg, 1, INSTR (new_att_catg, 'ALIAS_SEPARATOR') - 1)
541: )
542: INTO new_att_catg
543: FROM DUAL;
544: ELSE
545: -- new_att_catg:=get_exp_type_from_alias( new_att_catg);
546: new_att_catg :=
547: hxc_deposit_wrapper_utilities.get_dupdff_code (
564: --it will be either PAEXPITDFF - OT OR PAEXPITDFF - ST
565: if p_att_tab(att_dep_item).alias_type like 'VALUE%' then
566: SELECT decode(SUBSTR(new_att_catg,INSTR(new_att_catg,'ALIAS_SEPARATOR')+15),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
567: INTO new_att_catg
568: FROM DUAL;
569: else
570: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
571: INTO new_att_catg
572: FROM DUAL;
568: FROM DUAL;
569: else
570: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
571: INTO new_att_catg
572: FROM DUAL;
573: end if;
574: end if;*/
575: if g_debug then
576: hr_utility.trace('return new cat is '||new_att_catg);
941: and to_date(start_time,'dd-mm-rrrr') >=to_date(p_tc_frdt,'dd-mm-rrrr') and
942: to_date(stop_time,'dd-mm-rrrr') <=to_date(p_tc_todt,'dd-mm-rrrr')
943: union
944: select tc_frdt,tc_todt,to_date(tc_frdt)
945: from dual
946: order by 3;
947: */
948: SELECT TO_DATE (start_time, 'dd-mm-rrrr hh24:mi:ss') start_time,
949: TO_DATE (stop_time, 'dd-mm-rrrr hh24:mi:ss') stop_time, TO_DATE (start_time, 'dd-mm-rrrr') orddt
963: , 'dd-mm-rrrr hh24:mi:ss'),
964: TO_DATE (tc_frdt
965: /*ADVICE(935): Cursor references an external variable (use a parameter) [209] */
966: , 'dd-mm-rrrr')
967: FROM DUAL
968: ORDER BY 3;
969:
970: tc_tab_rec get_tc_data%ROWTYPE;
971: p_index NUMBER
2082: p_edit_allowed IN OUT NOCOPY VARCHAR2
2083: ) IS
2084: CURSOR csr_chk_transfer IS
2085: SELECT 1
2086: FROM DUAL
2087: WHERE EXISTS ( SELECT 1
2088: FROM hxc_transactions t, hxc_transaction_details td
2089: WHERE td.time_building_block_id = p_timecard_id
2090: /*ADVICE(1589): Cursor references an external variable (use a parameter) [209] */