[Home] [Help]
884: ,attribute27
885: ,attribute28
886: ,attribute29
887: ,attribute30
888: FROM pay_us_rpt_totals
889: WHERE business_group_id=cp_business_group_id
890: and attribute31=cp_csr
891: and session_id=cp_session_id
892: GROUP BY decode(upper(cp_sort_order1), 'PAYROLL NAME',attribute32,
966: ,attribute27
967: ,attribute28
968: ,attribute29
969: ,attribute30
970: FROM pay_us_rpt_totals
971: WHERE business_group_id=cp_business_group_id
972: AND attribute31=cp_csr
973: AND session_id=cp_session_id
974: GROUP BY
1017: gre_name)
1018: ,attribute34 --UOM
1019: ,sum(value1)
1020: ,sum(value2)
1021: FROM pay_us_rpt_totals
1022: WHERE session_id=cp_session_id
1023: AND business_group_id=cp_business_group_id
1024: AND attribute31=cp_total_flag
1025: GROUP BY decode(upper(cp_sort_order1), 'PAYROLL NAME',attribute32,
1035: ) IS
1036: SELECT attribute34 --UOM
1037: ,sum(value1)
1038: ,sum(value2)
1039: FROM pay_us_rpt_totals
1040: WHERE session_id=cp_session_id
1041: AND business_group_id=cp_business_group_id
1042: AND attribute31=cp_total_flag
1043: GROUP BY attribute34;
1419: IF p_output_file_type='HTML' AND lv_accrual_type = ' ' THEN
1420: lv_accrual_type:=' ';
1421: END IF;
1422:
1423: /*insert into pay_us_rpt_totals*/
1424: /*sackumar : this data is used in the report for geting the other section
1425: here atrributes1 to 30 used to store the values of the Segments 1 to 30
1426: and Attribute31 = 'CSR'
1427: Attribute32 = Payroll Name
1427: Attribute32 = Payroll Name
1428: Attribute33 = Concatenated Segments Value
1429: Attribute34 = UOM
1430: */
1431: insert into pay_us_rpt_totals(session_id,business_group_id,gre_name,value1 ,value2 ,attribute1,attribute2
1432: ,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8
1433: ,attribute9,attribute10,attribute11,attribute12,attribute13
1434: ,attribute14,attribute15,attribute16,attribute17,attribute18
1435: ,attribute19,attribute20,attribute21,attribute22,attribute23
2049: lv_data_row := null;
2050: END LOOP;
2051: CLOSE c_get_report_totals;
2052:
2053: DELETE FROM pay_us_rpt_totals where attribute31='CSR';
2054: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
2055: END costing_summary;
2056: --begin
2057: --hr_utility.trace_on(null, 'COSTING');