eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AE_SI_REPORTS dependencies on DUAL

Line 934: FROM dual;

930:
931: BEGIN
932: SELECT nvl(decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val),' ')
933: INTO l_fm_l_basic_val
934: FROM dual;
935:
936: EXCEPTION
937: WHEN no_data_found then
938: NULL;

Line 949: FROM dual;

945:
946: BEGIN
947: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
948: INTO l_fm_l_accomodation_val
949: FROM dual;
950:
951: EXCEPTION
952: WHEN no_data_found then
953: NULL;

Line 965: FROM dual;

961:
962: BEGIN
963: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
964: INTO l_fm_l_allowance_1_val
965: FROM dual;
966:
967: EXCEPTION
968: WHEN no_data_found then
969: NULL;

Line 981: FROM dual;

977:
978: BEGIN
979: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
980: INTO l_fm_l_allowance_2_val
981: FROM dual;
982:
983: EXCEPTION
984: WHEN no_data_found then
985: NULL;

Line 996: FROM dual;

992:
993: BEGIN
994: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
995: INTO l_fm_l_allowance_3_val
996: FROM dual;
997:
998: EXCEPTION
999: WHEN no_data_found then
1000: NULL;

Line 1011: FROM dual;

1007:
1008: BEGIN
1009: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
1010: INTO l_fm_l_allowance_4_val
1011: FROM dual;
1012:
1013: EXCEPTION
1014: WHEN no_data_found then
1015: NULL;

Line 1026: FROM dual;

1022:
1023: BEGIN
1024: SELECT decode(l_allowance_5_val/(abs(decode(l_allowance_5_val,0,1,l_allowance_5_val))*-1),1,'-'||l_fm_l_allowance_5_val,l_fm_l_allowance_5_val)
1025: INTO l_fm_l_allowance_5_val
1026: FROM dual;
1027:
1028: EXCEPTION
1029: WHEN no_data_found then
1030: NULL;

Line 1044: FROM dual;

1040:
1041: BEGIN
1042: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
1043: INTO l_fm_total_val
1044: FROM dual;
1045:
1046: EXCEPTION
1047: WHEN no_data_found then
1048: NULL;

Line 1831: FROM dual;

1827:
1828: BEGIN
1829: SELECT decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val)
1830: INTO l_fm_l_basic_val
1831: FROM dual;
1832:
1833: EXCEPTION
1834: WHEN no_data_found then
1835: NULL;

Line 1846: FROM dual;

1842:
1843: BEGIN
1844: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
1845: INTO l_fm_l_accomodation_val
1846: FROM dual;
1847:
1848: EXCEPTION
1849: WHEN no_data_found then
1850: NULL;

Line 1861: FROM dual;

1857:
1858: BEGIN
1859: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
1860: INTO l_fm_l_allowance_1_val
1861: FROM dual;
1862:
1863: EXCEPTION
1864: WHEN no_data_found then
1865: NULL;

Line 1876: FROM dual;

1872:
1873: BEGIN
1874: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
1875: INTO l_fm_l_allowance_2_val
1876: FROM dual;
1877:
1878: EXCEPTION
1879: WHEN no_data_found then
1880: NULL;

Line 1891: FROM dual;

1887:
1888: BEGIN
1889: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
1890: INTO l_fm_l_allowance_3_val
1891: FROM dual;
1892:
1893: EXCEPTION
1894: WHEN no_data_found then
1895: NULL;

Line 1906: FROM dual;

1902:
1903: BEGIN
1904: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
1905: INTO l_fm_l_allowance_4_val
1906: FROM dual;
1907:
1908: EXCEPTION
1909: WHEN no_data_found then
1910: NULL;

Line 1927: FROM dual;

1923:
1924: BEGIN
1925: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
1926: INTO l_fm_total_val
1927: FROM dual;
1928:
1929: EXCEPTION
1930: WHEN no_data_found then
1931: NULL;

Line 2451: FROM dual;

2447: BEGIN
2448:
2449: SELECT decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val)
2450: INTO l_fm_l_basic_val
2451: FROM dual;
2452:
2453: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
2454: INTO l_fm_l_accomodation_val
2455: FROM dual;

Line 2455: FROM dual;

2451: FROM dual;
2452:
2453: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
2454: INTO l_fm_l_accomodation_val
2455: FROM dual;
2456:
2457: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
2458: INTO l_fm_l_allowance_1_val
2459: FROM dual;

Line 2459: FROM dual;

2455: FROM dual;
2456:
2457: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
2458: INTO l_fm_l_allowance_1_val
2459: FROM dual;
2460:
2461: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
2462: INTO l_fm_l_allowance_2_val
2463: FROM dual;

Line 2463: FROM dual;

2459: FROM dual;
2460:
2461: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
2462: INTO l_fm_l_allowance_2_val
2463: FROM dual;
2464:
2465: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
2466: INTO l_fm_l_allowance_3_val
2467: FROM dual;

Line 2467: FROM dual;

2463: FROM dual;
2464:
2465: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
2466: INTO l_fm_l_allowance_3_val
2467: FROM dual;
2468:
2469: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
2470: INTO l_fm_l_allowance_4_val
2471: FROM dual;

Line 2471: FROM dual;

2467: FROM dual;
2468:
2469: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
2470: INTO l_fm_l_allowance_4_val
2471: FROM dual;
2472:
2473: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
2474: INTO l_fm_total_val
2475: FROM dual;

Line 2475: FROM dual;

2471: FROM dual;
2472:
2473: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
2474: INTO l_fm_total_val
2475: FROM dual;
2476:
2477: EXCEPTION
2478: WHEN no_data_found then
2479: null;

Line 2983: FROM dual;

2979: BEGIN
2980:
2981: SELECT decode(l_cur_total/(abs(decode(l_cur_total,0,1,l_cur_total))*-1),1,'-'||l_fm_l_cur_total,l_fm_l_cur_total)
2982: INTO l_fm_l_cur_total
2983: FROM dual;
2984:
2985: SELECT decode(l_prev_total/(abs(decode(l_prev_total,0,1,l_prev_total))*-1),1,'-'||l_fm_l_prev_total,l_fm_l_prev_total)
2986: INTO l_fm_l_prev_total
2987: FROM dual;

Line 2987: FROM dual;

2983: FROM dual;
2984:
2985: SELECT decode(l_prev_total/(abs(decode(l_prev_total,0,1,l_prev_total))*-1),1,'-'||l_fm_l_prev_total,l_fm_l_prev_total)
2986: INTO l_fm_l_prev_total
2987: FROM dual;
2988:
2989: SELECT decode(l_diff_total/(abs(decode(l_diff_total,0,1,l_diff_total))*-1),1,'-'||l_fm_l_diff_total,l_fm_l_diff_total)
2990: INTO l_fm_l_diff_total
2991: FROM dual;

Line 2991: FROM dual;

2987: FROM dual;
2988:
2989: SELECT decode(l_diff_total/(abs(decode(l_diff_total,0,1,l_diff_total))*-1),1,'-'||l_fm_l_diff_total,l_fm_l_diff_total)
2990: INTO l_fm_l_diff_total
2991: FROM dual;
2992:
2993:
2994: EXCEPTION
2995: WHEN no_data_found then

Line 3277: FROM dual;

3273: BEGIN
3274:
3275: SELECT decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val)
3276: INTO l_fm_l_basic_val
3277: FROM dual;
3278:
3279: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
3280: INTO l_fm_l_accomodation_val
3281: FROM dual;

Line 3281: FROM dual;

3277: FROM dual;
3278:
3279: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
3280: INTO l_fm_l_accomodation_val
3281: FROM dual;
3282:
3283: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
3284: INTO l_fm_l_allowance_1_val
3285: FROM dual;

Line 3285: FROM dual;

3281: FROM dual;
3282:
3283: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
3284: INTO l_fm_l_allowance_1_val
3285: FROM dual;
3286:
3287: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
3288: INTO l_fm_l_allowance_2_val
3289: FROM dual;

Line 3289: FROM dual;

3285: FROM dual;
3286:
3287: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
3288: INTO l_fm_l_allowance_2_val
3289: FROM dual;
3290:
3291: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
3292: INTO l_fm_l_allowance_3_val
3293: FROM dual;

Line 3293: FROM dual;

3289: FROM dual;
3290:
3291: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
3292: INTO l_fm_l_allowance_3_val
3293: FROM dual;
3294:
3295: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
3296: INTO l_fm_l_allowance_4_val
3297: FROM dual;

Line 3297: FROM dual;

3293: FROM dual;
3294:
3295: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
3296: INTO l_fm_l_allowance_4_val
3297: FROM dual;
3298:
3299: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
3300: INTO l_fm_total_val
3301: FROM dual;

Line 3301: FROM dual;

3297: FROM dual;
3298:
3299: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
3300: INTO l_fm_total_val
3301: FROM dual;
3302:
3303: SELECT decode(l_subject_si_val/(abs(decode(l_subject_si_val,0,1,l_subject_si_val))*-1),1,'-'||l_fm_subject_si_val,l_fm_subject_si_val)
3304: INTO l_fm_subject_si_val
3305: FROM dual;

Line 3305: FROM dual;

3301: FROM dual;
3302:
3303: SELECT decode(l_subject_si_val/(abs(decode(l_subject_si_val,0,1,l_subject_si_val))*-1),1,'-'||l_fm_subject_si_val,l_fm_subject_si_val)
3304: INTO l_fm_subject_si_val
3305: FROM dual;
3306:
3307: EXCEPTION
3308: WHEN no_data_found then
3309: null;

Line 3388: FROM dual;

3384: BEGIN
3385:
3386: SELECT decode(l_total_basic/(abs(decode(l_total_basic,0,1,l_total_basic))*-1),1,'-'||l_fm_l_total_basic,l_fm_l_total_basic)
3387: INTO l_fm_l_total_basic
3388: FROM dual;
3389:
3390: SELECT decode(L_TOTAL_HA/(abs(decode(L_TOTAL_HA,0,1,L_TOTAL_HA))*-1),1,'-'||l_fm_l_total_ha,l_fm_l_total_ha)
3391: INTO l_fm_l_total_ha
3392: FROM dual;

Line 3392: FROM dual;

3388: FROM dual;
3389:
3390: SELECT decode(L_TOTAL_HA/(abs(decode(L_TOTAL_HA,0,1,L_TOTAL_HA))*-1),1,'-'||l_fm_l_total_ha,l_fm_l_total_ha)
3391: INTO l_fm_l_total_ha
3392: FROM dual;
3393:
3394: SELECT decode(L_TOTAL_A1/(abs(decode(L_TOTAL_A1,0,1,L_TOTAL_A1))*-1),1,'-'||l_fm_l_total_a1,l_fm_l_total_a1)
3395: INTO l_fm_l_total_a1
3396: FROM dual;

Line 3396: FROM dual;

3392: FROM dual;
3393:
3394: SELECT decode(L_TOTAL_A1/(abs(decode(L_TOTAL_A1,0,1,L_TOTAL_A1))*-1),1,'-'||l_fm_l_total_a1,l_fm_l_total_a1)
3395: INTO l_fm_l_total_a1
3396: FROM dual;
3397:
3398: SELECT decode(L_TOTAL_A2/(abs(decode(L_TOTAL_A2,0,1,L_TOTAL_A2))*-1),1,'-'||l_fm_l_total_a2,l_fm_l_total_a2)
3399: INTO l_fm_l_total_a2
3400: FROM dual;

Line 3400: FROM dual;

3396: FROM dual;
3397:
3398: SELECT decode(L_TOTAL_A2/(abs(decode(L_TOTAL_A2,0,1,L_TOTAL_A2))*-1),1,'-'||l_fm_l_total_a2,l_fm_l_total_a2)
3399: INTO l_fm_l_total_a2
3400: FROM dual;
3401:
3402: SELECT decode(L_TOTAL_A3/(abs(decode(L_TOTAL_A3,0,1,L_TOTAL_A3))*-1),1,'-'||l_fm_l_total_a3,l_fm_l_total_a3)
3403: INTO l_fm_l_total_a3
3404: FROM dual;

Line 3404: FROM dual;

3400: FROM dual;
3401:
3402: SELECT decode(L_TOTAL_A3/(abs(decode(L_TOTAL_A3,0,1,L_TOTAL_A3))*-1),1,'-'||l_fm_l_total_a3,l_fm_l_total_a3)
3403: INTO l_fm_l_total_a3
3404: FROM dual;
3405:
3406: SELECT decode(L_TOTAL_A4/(abs(decode(L_TOTAL_A4,0,1,L_TOTAL_A4))*-1),1,'-'||l_fm_l_total_a4,l_fm_l_total_a4)
3407: INTO l_fm_l_total_a4
3408: FROM dual;

Line 3408: FROM dual;

3404: FROM dual;
3405:
3406: SELECT decode(L_TOTAL_A4/(abs(decode(L_TOTAL_A4,0,1,L_TOTAL_A4))*-1),1,'-'||l_fm_l_total_a4,l_fm_l_total_a4)
3407: INTO l_fm_l_total_a4
3408: FROM dual;
3409:
3410: SELECT decode(L_TOTAL_TOTAL/(abs(decode(L_TOTAL_TOTAL,0,1,L_TOTAL_TOTAL))*-1),1,'-'||l_fm_l_total_total,l_fm_l_total_total)
3411: INTO l_fm_l_total_total
3412: FROM dual;

Line 3412: FROM dual;

3408: FROM dual;
3409:
3410: SELECT decode(L_TOTAL_TOTAL/(abs(decode(L_TOTAL_TOTAL,0,1,L_TOTAL_TOTAL))*-1),1,'-'||l_fm_l_total_total,l_fm_l_total_total)
3411: INTO l_fm_l_total_total
3412: FROM dual;
3413:
3414: EXCEPTION
3415: WHEN no_data_found then
3416: null;

Line 3467: FROM dual;

3463: BEGIN
3464:
3465: SELECT decode(l_total_basic/(abs(decode(l_total_basic,0,1,l_total_basic))*-1),1,'-'||l_fm_l_total_basic,l_fm_l_total_basic)
3466: INTO l_fm_l_total_basic
3467: FROM dual;
3468:
3469: SELECT decode(L_TOTAL_HA/(abs(decode(L_TOTAL_HA,0,1,L_TOTAL_HA))*-1),1,'-'||l_fm_l_total_ha,l_fm_l_total_ha)
3470: INTO l_fm_l_total_ha
3471: FROM dual;

Line 3471: FROM dual;

3467: FROM dual;
3468:
3469: SELECT decode(L_TOTAL_HA/(abs(decode(L_TOTAL_HA,0,1,L_TOTAL_HA))*-1),1,'-'||l_fm_l_total_ha,l_fm_l_total_ha)
3470: INTO l_fm_l_total_ha
3471: FROM dual;
3472:
3473: SELECT decode(L_TOTAL_A1/(abs(decode(L_TOTAL_A1,0,1,L_TOTAL_A1))*-1),1,'-'||l_fm_l_total_a1,l_fm_l_total_a1)
3474: INTO l_fm_l_total_a1
3475: FROM dual;

Line 3475: FROM dual;

3471: FROM dual;
3472:
3473: SELECT decode(L_TOTAL_A1/(abs(decode(L_TOTAL_A1,0,1,L_TOTAL_A1))*-1),1,'-'||l_fm_l_total_a1,l_fm_l_total_a1)
3474: INTO l_fm_l_total_a1
3475: FROM dual;
3476:
3477: SELECT decode(L_TOTAL_A2/(abs(decode(L_TOTAL_A2,0,1,L_TOTAL_A2))*-1),1,'-'||l_fm_l_total_a2,l_fm_l_total_a2)
3478: INTO l_fm_l_total_a2
3479: FROM dual;

Line 3479: FROM dual;

3475: FROM dual;
3476:
3477: SELECT decode(L_TOTAL_A2/(abs(decode(L_TOTAL_A2,0,1,L_TOTAL_A2))*-1),1,'-'||l_fm_l_total_a2,l_fm_l_total_a2)
3478: INTO l_fm_l_total_a2
3479: FROM dual;
3480:
3481: SELECT decode(L_TOTAL_A3/(abs(decode(L_TOTAL_A3,0,1,L_TOTAL_A3))*-1),1,'-'||l_fm_l_total_a3,l_fm_l_total_a3)
3482: INTO l_fm_l_total_a3
3483: FROM dual;

Line 3483: FROM dual;

3479: FROM dual;
3480:
3481: SELECT decode(L_TOTAL_A3/(abs(decode(L_TOTAL_A3,0,1,L_TOTAL_A3))*-1),1,'-'||l_fm_l_total_a3,l_fm_l_total_a3)
3482: INTO l_fm_l_total_a3
3483: FROM dual;
3484:
3485: SELECT decode(L_TOTAL_A4/(abs(decode(L_TOTAL_A4,0,1,L_TOTAL_A4))*-1),1,'-'||l_fm_l_total_a4,l_fm_l_total_a4)
3486: INTO l_fm_l_total_a4
3487: FROM dual;

Line 3487: FROM dual;

3483: FROM dual;
3484:
3485: SELECT decode(L_TOTAL_A4/(abs(decode(L_TOTAL_A4,0,1,L_TOTAL_A4))*-1),1,'-'||l_fm_l_total_a4,l_fm_l_total_a4)
3486: INTO l_fm_l_total_a4
3487: FROM dual;
3488:
3489: SELECT decode(L_TOTAL_TOTAL/(abs(decode(L_TOTAL_TOTAL,0,1,L_TOTAL_TOTAL))*-1),1,'-'||l_fm_l_total_total,l_fm_l_total_total)
3490: INTO l_fm_l_total_total
3491: FROM dual;

Line 3491: FROM dual;

3487: FROM dual;
3488:
3489: SELECT decode(L_TOTAL_TOTAL/(abs(decode(L_TOTAL_TOTAL,0,1,L_TOTAL_TOTAL))*-1),1,'-'||l_fm_l_total_total,l_fm_l_total_total)
3490: INTO l_fm_l_total_total
3491: FROM dual;
3492:
3493: EXCEPTION
3494: WHEN no_data_found then
3495: null;

Line 3557: FROM dual;

3553:
3554: BEGIN
3555: SELECT decode(l_subject_si_val/(abs(decode(l_subject_si_val,0,1,l_subject_si_val))*-1),1,'-'||l_fm_subject_si_val,l_fm_subject_si_val)
3556: INTO l_fm_subject_si_val
3557: FROM dual;
3558:
3559: EXCEPTION
3560: WHEN no_data_found then
3561: null;

Line 3595: FROM dual;

3591:
3592: BEGIN
3593: SELECT decode(l_total_term/(abs(decode(l_total_term,0,1,l_total_term))*-1),1,'-'||l_fm_l_total_term,l_fm_l_total_term)
3594: INTO l_fm_l_total_term
3595: FROM dual;
3596:
3597: EXCEPTION
3598: WHEN no_data_found then
3599: null;

Line 3618: FROM dual;

3614:
3615: BEGIN
3616: SELECT decode(l_total_term/(abs(decode(l_total_term,0,1,l_total_term))*-1),1,'-'||l_fm_l_total_term,l_fm_l_total_term)
3617: INTO l_fm_l_total_term
3618: FROM dual;
3619:
3620: EXCEPTION
3621: WHEN no_data_found then
3622: null;

Line 3658: FROM dual;

3654:
3655: BEGIN
3656: SELECT decode(l_subject_si_val/(abs(decode(l_subject_si_val,0,1,l_subject_si_val))*-1),1,'-'||l_fm_changed_salary,l_fm_changed_salary)
3657: INTO l_fm_changed_salary
3658: FROM dual;
3659:
3660: EXCEPTION
3661: WHEN no_data_found then
3662: null;

Line 3696: FROM dual;

3692:
3693: BEGIN
3694: SELECT decode(l_total_change/(abs(decode(l_total_change,0,1,l_total_change))*-1),1,'-'||l_fm_l_total_change,l_fm_l_total_change)
3695: INTO l_fm_l_total_change
3696: FROM dual;
3697:
3698: EXCEPTION
3699: WHEN no_data_found then
3700: null;

Line 3719: FROM dual;

3715:
3716: BEGIN
3717: SELECT decode(l_total_change/(abs(decode(l_total_change,0,1,l_total_change))*-1),1,'-'||l_fm_l_total_change,l_fm_l_total_change)
3718: INTO l_fm_l_total_change
3719: FROM dual;
3720:
3721: EXCEPTION
3722: WHEN no_data_found then
3723: null;

Line 4209: FROM dual;

4205:
4206: BEGIN
4207: SELECT decode(l_ee_contribution/(abs(decode(l_ee_contribution,0,1,l_ee_contribution))*-1),1,'-'||l_fm_ee_contribution,l_fm_ee_contribution)
4208: INTO l_fm_ee_contribution
4209: FROM dual;
4210:
4211: SELECT decode(l_er_contribution/(abs(decode(l_er_contribution,0,1,l_er_contribution))*-1),1,'-'||l_fm_er_contribution,l_fm_er_contribution)
4212: INTO l_fm_er_contribution
4213: FROM dual;

Line 4213: FROM dual;

4209: FROM dual;
4210:
4211: SELECT decode(l_er_contribution/(abs(decode(l_er_contribution,0,1,l_er_contribution))*-1),1,'-'||l_fm_er_contribution,l_fm_er_contribution)
4212: INTO l_fm_er_contribution
4213: FROM dual;
4214:
4215: SELECT decode(l_total_contribution/(abs(decode(l_total_contribution,0,1,l_total_contribution))*-1),1,'-'||l_fm_total_contribution,l_fm_total_contribution)
4216: INTO l_fm_total_contribution
4217: FROM dual;

Line 4217: FROM dual;

4213: FROM dual;
4214:
4215: SELECT decode(l_total_contribution/(abs(decode(l_total_contribution,0,1,l_total_contribution))*-1),1,'-'||l_fm_total_contribution,l_fm_total_contribution)
4216: INTO l_fm_total_contribution
4217: FROM dual;
4218:
4219: SELECT decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val)
4220: INTO l_fm_l_basic_val
4221: FROM dual;

Line 4221: FROM dual;

4217: FROM dual;
4218:
4219: SELECT decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val)
4220: INTO l_fm_l_basic_val
4221: FROM dual;
4222:
4223: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
4224: INTO l_fm_l_accomodation_val
4225: FROM dual;

Line 4225: FROM dual;

4221: FROM dual;
4222:
4223: SELECT decode(l_accomodation_val/(abs(decode(l_accomodation_val,0,1,l_accomodation_val))*-1),1,'-'||l_fm_l_accomodation_val,l_fm_l_accomodation_val)
4224: INTO l_fm_l_accomodation_val
4225: FROM dual;
4226:
4227: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
4228: INTO l_fm_l_allowance_1_val
4229: FROM dual;

Line 4229: FROM dual;

4225: FROM dual;
4226:
4227: SELECT decode(l_allowance_1_val/(abs(decode(l_allowance_1_val,0,1,l_allowance_1_val))*-1),1,'-'||l_fm_l_allowance_1_val,l_fm_l_allowance_1_val)
4228: INTO l_fm_l_allowance_1_val
4229: FROM dual;
4230:
4231: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
4232: INTO l_fm_l_allowance_2_val
4233: FROM dual;

Line 4233: FROM dual;

4229: FROM dual;
4230:
4231: SELECT decode(l_allowance_2_val/(abs(decode(l_allowance_2_val,0,1,l_allowance_2_val))*-1),1,'-'||l_fm_l_allowance_2_val,l_fm_l_allowance_2_val)
4232: INTO l_fm_l_allowance_2_val
4233: FROM dual;
4234:
4235: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
4236: INTO l_fm_l_allowance_3_val
4237: FROM dual;

Line 4237: FROM dual;

4233: FROM dual;
4234:
4235: SELECT decode(l_allowance_3_val/(abs(decode(l_allowance_3_val,0,1,l_allowance_3_val))*-1),1,'-'||l_fm_l_allowance_3_val,l_fm_l_allowance_3_val)
4236: INTO l_fm_l_allowance_3_val
4237: FROM dual;
4238:
4239: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
4240: INTO l_fm_l_allowance_4_val
4241: FROM dual;

Line 4241: FROM dual;

4237: FROM dual;
4238:
4239: SELECT decode(l_allowance_4_val/(abs(decode(l_allowance_4_val,0,1,l_allowance_4_val))*-1),1,'-'||l_fm_l_allowance_4_val,l_fm_l_allowance_4_val)
4240: INTO l_fm_l_allowance_4_val
4241: FROM dual;
4242:
4243: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
4244: INTO l_fm_total_val
4245: FROM dual;

Line 4245: FROM dual;

4241: FROM dual;
4242:
4243: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
4244: INTO l_fm_total_val
4245: FROM dual;
4246:
4247: EXCEPTION
4248: WHEN no_data_found then
4249: null;

Line 4333: FROM dual;

4329:
4330: BEGIN
4331: SELECT decode(l_total_basic/(abs(decode(l_total_basic,0,1,l_total_basic))*-1),1,'-'||l_fm_total_basic,l_fm_total_basic)
4332: INTO l_fm_total_basic
4333: FROM dual;
4334:
4335: SELECT decode(l_total_aa/(abs(decode(l_total_aa,0,1,l_total_aa))*-1),1,'-'||l_fm_total_aa,l_fm_total_aa)
4336: INTO l_fm_total_aa
4337: FROM dual;

Line 4337: FROM dual;

4333: FROM dual;
4334:
4335: SELECT decode(l_total_aa/(abs(decode(l_total_aa,0,1,l_total_aa))*-1),1,'-'||l_fm_total_aa,l_fm_total_aa)
4336: INTO l_fm_total_aa
4337: FROM dual;
4338:
4339: SELECT decode(l_total_a1/(abs(decode(l_total_a1,0,1,l_total_a1))*-1),1,'-'||l_fm_total_a1,l_fm_total_a1)
4340: INTO l_fm_total_a1
4341: FROM dual;

Line 4341: FROM dual;

4337: FROM dual;
4338:
4339: SELECT decode(l_total_a1/(abs(decode(l_total_a1,0,1,l_total_a1))*-1),1,'-'||l_fm_total_a1,l_fm_total_a1)
4340: INTO l_fm_total_a1
4341: FROM dual;
4342:
4343: SELECT decode(l_total_a2/(abs(decode(l_total_a2,0,1,l_total_a2))*-1),1,'-'||l_fm_total_a2,l_fm_total_a2)
4344: INTO l_fm_total_a2
4345: FROM dual;

Line 4345: FROM dual;

4341: FROM dual;
4342:
4343: SELECT decode(l_total_a2/(abs(decode(l_total_a2,0,1,l_total_a2))*-1),1,'-'||l_fm_total_a2,l_fm_total_a2)
4344: INTO l_fm_total_a2
4345: FROM dual;
4346:
4347: SELECT decode(l_total_a3/(abs(decode(l_total_a3,0,1,l_total_a3))*-1),1,'-'||l_fm_total_a3,l_fm_total_a3)
4348: INTO l_fm_total_a3
4349: FROM dual;

Line 4349: FROM dual;

4345: FROM dual;
4346:
4347: SELECT decode(l_total_a3/(abs(decode(l_total_a3,0,1,l_total_a3))*-1),1,'-'||l_fm_total_a3,l_fm_total_a3)
4348: INTO l_fm_total_a3
4349: FROM dual;
4350:
4351: SELECT decode(l_total_ee/(abs(decode(l_total_ee,0,1,l_total_ee))*-1),1,'-'||l_fm_total_ee,l_fm_total_ee)
4352: INTO l_fm_total_ee
4353: FROM dual;

Line 4353: FROM dual;

4349: FROM dual;
4350:
4351: SELECT decode(l_total_ee/(abs(decode(l_total_ee,0,1,l_total_ee))*-1),1,'-'||l_fm_total_ee,l_fm_total_ee)
4352: INTO l_fm_total_ee
4353: FROM dual;
4354:
4355: SELECT decode(l_total_er/(abs(decode(l_total_er,0,1,l_total_er))*-1),1,'-'||l_fm_total_er,l_fm_total_er)
4356: INTO l_fm_total_er
4357: FROM dual;

Line 4357: FROM dual;

4353: FROM dual;
4354:
4355: SELECT decode(l_total_er/(abs(decode(l_total_er,0,1,l_total_er))*-1),1,'-'||l_fm_total_er,l_fm_total_er)
4356: INTO l_fm_total_er
4357: FROM dual;
4358:
4359: SELECT decode(l_total_total/(abs(decode(l_total_total,0,1,l_total_total))*-1),1,'-'||l_fm_total_total,l_fm_total_total)
4360: INTO l_fm_total_total
4361: FROM dual;

Line 4361: FROM dual;

4357: FROM dual;
4358:
4359: SELECT decode(l_total_total/(abs(decode(l_total_total,0,1,l_total_total))*-1),1,'-'||l_fm_total_total,l_fm_total_total)
4360: INTO l_fm_total_total
4361: FROM dual;
4362:
4363:
4364: EXCEPTION
4365: WHEN no_data_found then

Line 4437: FROM dual;

4433:
4434: BEGIN
4435: SELECT decode(l_total_basic/(abs(decode(l_total_basic,0,1,l_total_basic))*-1),1,'-'||l_fm_total_basic,l_fm_total_basic)
4436: INTO l_fm_total_basic
4437: FROM dual;
4438:
4439: SELECT decode(l_total_aa/(abs(decode(l_total_aa,0,1,l_total_aa))*-1),1,'-'||l_fm_total_aa,l_fm_total_aa)
4440: INTO l_fm_total_aa
4441: FROM dual;

Line 4441: FROM dual;

4437: FROM dual;
4438:
4439: SELECT decode(l_total_aa/(abs(decode(l_total_aa,0,1,l_total_aa))*-1),1,'-'||l_fm_total_aa,l_fm_total_aa)
4440: INTO l_fm_total_aa
4441: FROM dual;
4442:
4443: SELECT decode(l_total_a1/(abs(decode(l_total_a1,0,1,l_total_a1))*-1),1,'-'||l_fm_total_a1,l_fm_total_a1)
4444: INTO l_fm_total_a1
4445: FROM dual;

Line 4445: FROM dual;

4441: FROM dual;
4442:
4443: SELECT decode(l_total_a1/(abs(decode(l_total_a1,0,1,l_total_a1))*-1),1,'-'||l_fm_total_a1,l_fm_total_a1)
4444: INTO l_fm_total_a1
4445: FROM dual;
4446:
4447: SELECT decode(l_total_a2/(abs(decode(l_total_a2,0,1,l_total_a2))*-1),1,'-'||l_fm_total_a2,l_fm_total_a2)
4448: INTO l_fm_total_a2
4449: FROM dual;

Line 4449: FROM dual;

4445: FROM dual;
4446:
4447: SELECT decode(l_total_a2/(abs(decode(l_total_a2,0,1,l_total_a2))*-1),1,'-'||l_fm_total_a2,l_fm_total_a2)
4448: INTO l_fm_total_a2
4449: FROM dual;
4450:
4451: SELECT decode(l_total_a3/(abs(decode(l_total_a3,0,1,l_total_a3))*-1),1,'-'||l_fm_total_a3,l_fm_total_a3)
4452: INTO l_fm_total_a3
4453: FROM dual;

Line 4453: FROM dual;

4449: FROM dual;
4450:
4451: SELECT decode(l_total_a3/(abs(decode(l_total_a3,0,1,l_total_a3))*-1),1,'-'||l_fm_total_a3,l_fm_total_a3)
4452: INTO l_fm_total_a3
4453: FROM dual;
4454:
4455: SELECT decode(l_total_ee/(abs(decode(l_total_ee,0,1,l_total_ee))*-1),1,'-'||l_fm_total_ee,l_fm_total_ee)
4456: INTO l_fm_total_ee
4457: FROM dual;

Line 4457: FROM dual;

4453: FROM dual;
4454:
4455: SELECT decode(l_total_ee/(abs(decode(l_total_ee,0,1,l_total_ee))*-1),1,'-'||l_fm_total_ee,l_fm_total_ee)
4456: INTO l_fm_total_ee
4457: FROM dual;
4458:
4459: SELECT decode(l_total_er/(abs(decode(l_total_er,0,1,l_total_er))*-1),1,'-'||l_fm_total_er,l_fm_total_er)
4460: INTO l_fm_total_er
4461: FROM dual;

Line 4461: FROM dual;

4457: FROM dual;
4458:
4459: SELECT decode(l_total_er/(abs(decode(l_total_er,0,1,l_total_er))*-1),1,'-'||l_fm_total_er,l_fm_total_er)
4460: INTO l_fm_total_er
4461: FROM dual;
4462:
4463: SELECT decode(l_total_total/(abs(decode(l_total_total,0,1,l_total_total))*-1),1,'-'||l_fm_total_total,l_fm_total_total)
4464: INTO l_fm_total_total
4465: FROM dual;

Line 4465: FROM dual;

4461: FROM dual;
4462:
4463: SELECT decode(l_total_total/(abs(decode(l_total_total,0,1,l_total_total))*-1),1,'-'||l_fm_total_total,l_fm_total_total)
4464: INTO l_fm_total_total
4465: FROM dual;
4466:
4467:
4468: EXCEPTION
4469: WHEN no_data_found then

Line 4885: FROM dual;

4881:
4882: BEGIN
4883: SELECT decode(l_basic_val/(abs(decode(l_basic_val,0,1,l_basic_val))*-1),1,'-'||l_fm_l_basic_val,l_fm_l_basic_val)
4884: INTO l_fm_l_basic_val
4885: FROM dual;
4886:
4887: SELECT decode(l_cost_of_living_val/(abs(decode(l_cost_of_living_val,0,1,l_cost_of_living_val))*-1),1,'-'||l_fm_l_cost_of_living_val,l_fm_l_cost_of_living_val)
4888: INTO l_fm_l_cost_of_living_val
4889: FROM dual;

Line 4889: FROM dual;

4885: FROM dual;
4886:
4887: SELECT decode(l_cost_of_living_val/(abs(decode(l_cost_of_living_val,0,1,l_cost_of_living_val))*-1),1,'-'||l_fm_l_cost_of_living_val,l_fm_l_cost_of_living_val)
4888: INTO l_fm_l_cost_of_living_val
4889: FROM dual;
4890:
4891: SELECT decode(l_social_allow_val/(abs(decode(l_social_allow_val,0,1,l_social_allow_val))*-1),1,'-'||l_fm_l_social_allow_val,l_fm_l_social_allow_val)
4892: INTO l_fm_l_social_allow_val
4893: FROM dual;

Line 4893: FROM dual;

4889: FROM dual;
4890:
4891: SELECT decode(l_social_allow_val/(abs(decode(l_social_allow_val,0,1,l_social_allow_val))*-1),1,'-'||l_fm_l_social_allow_val,l_fm_l_social_allow_val)
4892: INTO l_fm_l_social_allow_val
4893: FROM dual;
4894:
4895: SELECT decode(l_child_allow_val/(abs(decode(l_child_allow_val,0,1,l_child_allow_val))*-1),1,'-'||l_fm_l_child_allow_val,l_fm_l_child_allow_val)
4896: INTO l_fm_l_child_allow_val
4897: FROM dual;

Line 4897: FROM dual;

4893: FROM dual;
4894:
4895: SELECT decode(l_child_allow_val/(abs(decode(l_child_allow_val,0,1,l_child_allow_val))*-1),1,'-'||l_fm_l_child_allow_val,l_fm_l_child_allow_val)
4896: INTO l_fm_l_child_allow_val
4897: FROM dual;
4898:
4899: SELECT decode(l_accommodation_val/(abs(decode(l_accommodation_val,0,1,l_accommodation_val))*-1),1,'-'||l_fm_l_accommodation_val,l_fm_l_accommodation_val)
4900: INTO l_fm_l_accommodation_val
4901: FROM dual;

Line 4901: FROM dual;

4897: FROM dual;
4898:
4899: SELECT decode(l_accommodation_val/(abs(decode(l_accommodation_val,0,1,l_accommodation_val))*-1),1,'-'||l_fm_l_accommodation_val,l_fm_l_accommodation_val)
4900: INTO l_fm_l_accommodation_val
4901: FROM dual;
4902:
4903:
4904: EXCEPTION
4905: WHEN no_data_found then

Line 4954: FROM dual;

4950:
4951: BEGIN
4952: SELECT decode(l_total/(abs(decode(l_total,0,1,l_total))*-1),1,'-'||l_fm_total_val,l_fm_total_val)
4953: INTO l_fm_total_val
4954: FROM dual;
4955:
4956: SELECT decode(l_employee_cont/(abs(decode(l_employee_cont,0,1,l_employee_cont))*-1),1,'-'||l_fm_ee_cont_total,l_fm_ee_cont_total)
4957: INTO l_fm_ee_cont_total
4958: FROM dual;

Line 4958: FROM dual;

4954: FROM dual;
4955:
4956: SELECT decode(l_employee_cont/(abs(decode(l_employee_cont,0,1,l_employee_cont))*-1),1,'-'||l_fm_ee_cont_total,l_fm_ee_cont_total)
4957: INTO l_fm_ee_cont_total
4958: FROM dual;
4959:
4960: SELECT decode(l_employer_cont/(abs(decode(l_employer_cont,0,1,l_employer_cont))*-1),1,'-'||l_fm_er_cont_total,l_fm_er_cont_total)
4961: INTO l_fm_er_cont_total
4962: FROM dual;

Line 4962: FROM dual;

4958: FROM dual;
4959:
4960: SELECT decode(l_employer_cont/(abs(decode(l_employer_cont,0,1,l_employer_cont))*-1),1,'-'||l_fm_er_cont_total,l_fm_er_cont_total)
4961: INTO l_fm_er_cont_total
4962: FROM dual;
4963:
4964: SELECT decode(l_total_cont/(abs(decode(l_total_cont,0,1,l_total_cont))*-1),1,'-'||l_fm_total_cont,l_fm_total_cont)
4965: INTO l_fm_total_cont
4966: FROM dual;

Line 4966: FROM dual;

4962: FROM dual;
4963:
4964: SELECT decode(l_total_cont/(abs(decode(l_total_cont,0,1,l_total_cont))*-1),1,'-'||l_fm_total_cont,l_fm_total_cont)
4965: INTO l_fm_total_cont
4966: FROM dual;
4967:
4968: EXCEPTION
4969: WHEN no_data_found then
4970: null;

Line 5060: FROM dual;

5056:
5057: BEGIN
5058: SELECT decode(l_basic_total/(abs(decode(l_basic_total,0,1,l_basic_total))*-1),1,'-'||l_fm_l_basic_total,l_fm_l_basic_total)
5059: INTO l_fm_l_basic_total
5060: FROM dual;
5061:
5062: SELECT decode(l_basic_total/(abs(decode(l_basic_total,0,1,l_basic_total))*-1),1,'-'||l_fm_l_col_total,l_fm_l_col_total)
5063: INTO l_fm_l_col_total
5064: FROM dual;

Line 5064: FROM dual;

5060: FROM dual;
5061:
5062: SELECT decode(l_basic_total/(abs(decode(l_basic_total,0,1,l_basic_total))*-1),1,'-'||l_fm_l_col_total,l_fm_l_col_total)
5063: INTO l_fm_l_col_total
5064: FROM dual;
5065:
5066: SELECT decode(l_social_total/(abs(decode(l_social_total,0,1,l_social_total))*-1),1,'-'||l_fm_l_social_total,l_fm_l_social_total)
5067: INTO l_fm_l_social_total
5068: FROM dual;

Line 5068: FROM dual;

5064: FROM dual;
5065:
5066: SELECT decode(l_social_total/(abs(decode(l_social_total,0,1,l_social_total))*-1),1,'-'||l_fm_l_social_total,l_fm_l_social_total)
5067: INTO l_fm_l_social_total
5068: FROM dual;
5069:
5070: SELECT decode(l_child_total/(abs(decode(l_child_total,0,1,l_child_total))*-1),1,'-'||l_fm_l_child_total,l_fm_l_child_total)
5071: INTO l_fm_l_child_total
5072: FROM dual;

Line 5072: FROM dual;

5068: FROM dual;
5069:
5070: SELECT decode(l_child_total/(abs(decode(l_child_total,0,1,l_child_total))*-1),1,'-'||l_fm_l_child_total,l_fm_l_child_total)
5071: INTO l_fm_l_child_total
5072: FROM dual;
5073:
5074: SELECT decode(l_acco_total/(abs(decode(l_acco_total,0,1,l_acco_total))*-1),1,'-'||l_fm_l_acco_total,l_fm_l_acco_total)
5075: INTO l_fm_l_acco_total
5076: FROM dual;

Line 5076: FROM dual;

5072: FROM dual;
5073:
5074: SELECT decode(l_acco_total/(abs(decode(l_acco_total,0,1,l_acco_total))*-1),1,'-'||l_fm_l_acco_total,l_fm_l_acco_total)
5075: INTO l_fm_l_acco_total
5076: FROM dual;
5077:
5078: SELECT decode(l_total_allow_total/(abs(decode(l_total_allow_total,0,1,l_total_allow_total))*-1),1,'-'||l_fm_l_total_allow_total,l_fm_l_total_allow_total)
5079: INTO l_fm_l_total_allow_total
5080: FROM dual;

Line 5080: FROM dual;

5076: FROM dual;
5077:
5078: SELECT decode(l_total_allow_total/(abs(decode(l_total_allow_total,0,1,l_total_allow_total))*-1),1,'-'||l_fm_l_total_allow_total,l_fm_l_total_allow_total)
5079: INTO l_fm_l_total_allow_total
5080: FROM dual;
5081:
5082: SELECT decode(l_total_ee_cont_total/(abs(decode(l_total_ee_cont_total,0,1,l_total_ee_cont_total))*-1),1,'-'||l_fm_total_ee_cont_total,l_fm_total_ee_cont_total)
5083: INTO l_fm_total_ee_cont_total
5084: FROM dual;

Line 5084: FROM dual;

5080: FROM dual;
5081:
5082: SELECT decode(l_total_ee_cont_total/(abs(decode(l_total_ee_cont_total,0,1,l_total_ee_cont_total))*-1),1,'-'||l_fm_total_ee_cont_total,l_fm_total_ee_cont_total)
5083: INTO l_fm_total_ee_cont_total
5084: FROM dual;
5085:
5086: SELECT decode(l_total_er_cont_total/(abs(decode(l_total_er_cont_total,0,1,l_total_er_cont_total))*-1),1,'-'||l_fm_total_er_cont_total,l_fm_total_er_cont_total)
5087: INTO l_fm_total_er_cont_total
5088: FROM dual;

Line 5088: FROM dual;

5084: FROM dual;
5085:
5086: SELECT decode(l_total_er_cont_total/(abs(decode(l_total_er_cont_total,0,1,l_total_er_cont_total))*-1),1,'-'||l_fm_total_er_cont_total,l_fm_total_er_cont_total)
5087: INTO l_fm_total_er_cont_total
5088: FROM dual;
5089:
5090: SELECT decode(l_total_cont_total/(abs(decode(l_total_cont_total,0,1,l_total_cont_total))*-1),1,'-'||l_fm_total_cont_total,l_fm_total_cont_total)
5091: INTO l_fm_total_cont_total
5092: FROM dual;

Line 5092: FROM dual;

5088: FROM dual;
5089:
5090: SELECT decode(l_total_cont_total/(abs(decode(l_total_cont_total,0,1,l_total_cont_total))*-1),1,'-'||l_fm_total_cont_total,l_fm_total_cont_total)
5091: INTO l_fm_total_cont_total
5092: FROM dual;
5093:
5094: EXCEPTION
5095: WHEN no_data_found then
5096: null;

Line 5330: select userenv('LANGUAGE') into g_nls_db_char from dual;

5326: l_blob_offset pls_integer := 1;
5327: begin
5328: l_buffer_len := 20000;
5329: hr_utility.set_location('Entered Procedure clob to blob',120);
5330: select userenv('LANGUAGE') into g_nls_db_char from dual;
5331: l_length_clob := dbms_lob.getlength(p_clob);
5332: l_offset := 1;
5333: while l_length_clob > 0 loop
5334: hr_utility.trace('l_length_clob '|| l_length_clob);