[Home] [Help]
505: 'OT', 'PAEXPITDFF - OT',
506: 'PAEXPITDFF - ST'
507: )
508: INTO new_att_catg
509: FROM DUAL;
510: ELSE
511: SELECT DECODE (
512: hxc_alias_utility.get_sfl_from_alias_value (new_att_catg),
513: 'OT', 'PAEXPITDFF - OT',
513: 'OT', 'PAEXPITDFF - OT',
514: 'PAEXPITDFF - ST'
515: )
516: INTO new_att_catg
517: FROM DUAL;
518: END IF;
519: ELSIF l_reference_field = 'EXPENDITURE_TYPE' THEN
520: IF p_att_tab (att_dep_item).alias_type LIKE 'VALUE%' THEN
521: SELECT hxc_deposit_wrapper_utilities.get_dupdff_code (
521: SELECT hxc_deposit_wrapper_utilities.get_dupdff_code (
522: 'PAEXPITDFF - '|| SUBSTR (new_att_catg, 1, INSTR (new_att_catg, 'ALIAS_SEPARATOR') - 1)
523: )
524: INTO new_att_catg
525: FROM DUAL;
526: ELSE
527: -- new_att_catg:=get_exp_type_from_alias( new_att_catg);
528: new_att_catg :=
529: hxc_deposit_wrapper_utilities.get_dupdff_code (
546: --it will be either PAEXPITDFF - OT OR PAEXPITDFF - ST
547: if p_att_tab(att_dep_item).alias_type like 'VALUE%' then
548: SELECT decode(SUBSTR(new_att_catg,INSTR(new_att_catg,'ALIAS_SEPARATOR')+15),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
549: INTO new_att_catg
550: FROM DUAL;
551: else
552: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
553: INTO new_att_catg
554: FROM DUAL;
550: FROM DUAL;
551: else
552: select decode(hxc_alias_utility.get_sfl_from_alias_value(new_att_catg),'OT','PAEXPITDFF - OT','PAEXPITDFF - ST')
553: INTO new_att_catg
554: FROM DUAL;
555: end if;
556: end if;*/
557: if g_debug then
558: hr_utility.trace('return new cat is '||new_att_catg);
923: and to_date(start_time,'dd-mm-rrrr') >=to_date(p_tc_frdt,'dd-mm-rrrr') and
924: to_date(stop_time,'dd-mm-rrrr') <=to_date(p_tc_todt,'dd-mm-rrrr')
925: union
926: select tc_frdt,tc_todt,to_date(tc_frdt)
927: from dual
928: order by 3;
929: */
930: SELECT TO_DATE (start_time, 'dd-mm-rrrr hh24:mi:ss') start_time,
931: TO_DATE (stop_time, 'dd-mm-rrrr hh24:mi:ss') stop_time, TO_DATE (start_time, 'dd-mm-rrrr') orddt
945: , 'dd-mm-rrrr hh24:mi:ss'),
946: TO_DATE (tc_frdt
947: /*ADVICE(935): Cursor references an external variable (use a parameter) [209] */
948: , 'dd-mm-rrrr')
949: FROM DUAL
950: ORDER BY 3;
951:
952: tc_tab_rec get_tc_data%ROWTYPE;
953: p_index NUMBER
2064: p_edit_allowed IN OUT NOCOPY VARCHAR2
2065: ) IS
2066: CURSOR csr_chk_transfer IS
2067: SELECT 1
2068: FROM DUAL
2069: WHERE EXISTS ( SELECT 1
2070: FROM hxc_transactions t, hxc_transaction_details td
2071: WHERE td.time_building_block_id = p_timecard_id
2072: /*ADVICE(1589): Cursor references an external variable (use a parameter) [209] */