APPS.PAY_COSTING_SUMMARY_X_REP_PKG dependencies on PAY_US_RPT_TOTALS

Line 326: FROM pay_us_rpt_totals

322: ,attribute19
323: ,attribute20
324: ,attribute21
325: ,attribute22
326: FROM pay_us_rpt_totals
327: WHERE business_group_id=cp_business_group_id
328: AND cp_csr='CSR'
329: AND session_id=cp_session_id
330: GROUP BY decode(upper(cp_sort_order1), 'PAYROLL NAME',attribute2,

Line 386: FROM pay_us_rpt_totals

382: ,attribute19
383: ,attribute20
384: ,attribute21
385: ,attribute22
386: FROM pay_us_rpt_totals
387: WHERE business_group_id=cp_business_group_id
388: AND cp_csr='CSR'
389: AND session_id=cp_session_id
390: GROUP BY

Line 429: FROM pay_us_rpt_totals

425: gre_name)
426: ,attribute24 --UOM
427: ,sum(value1)
428: ,sum(value2)
429: FROM pay_us_rpt_totals
430: WHERE session_id=cp_session_id
431: AND business_group_id=cp_business_group_id
432: AND attribute1=cp_total_flag
433: GROUP BY decode(upper(cp_sort_order1), 'PAYROLL NAME',attribute2,

Line 447: FROM pay_us_rpt_totals

443: ) IS
444: SELECT attribute24 --UOM
445: ,SUM(value1)
446: ,SUM(value2)
447: FROM pay_us_rpt_totals
448: WHERE session_id=cp_session_id
449: AND business_group_id=cp_business_group_id
450: AND attribute1=cp_total_flag
451: GROUP BY attribute24;

Line 787: /*insert into pay_us_rpt_totals*/

783: '0');
784: END IF;
785: l_rec_count := l_rec_count + 1;
786: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
787: /*insert into pay_us_rpt_totals*/
788: insert INTO pay_us_rpt_totals(session_id,business_group_id,gre_name,value1,
789: value2 ,attribute1,attribute2,attribute3,
790: attribute4,attribute5,attribute6,attribute7,
791: attribute8,attribute9,attribute10,

Line 788: insert INTO pay_us_rpt_totals(session_id,business_group_id,gre_name,value1,

784: END IF;
785: l_rec_count := l_rec_count + 1;
786: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
787: /*insert into pay_us_rpt_totals*/
788: insert INTO pay_us_rpt_totals(session_id,business_group_id,gre_name,value1,
789: value2 ,attribute1,attribute2,attribute3,
790: attribute4,attribute5,attribute6,attribute7,
791: attribute8,attribute9,attribute10,
792: attribute11,attribute12,attribute13,

Line 1421: DELETE FROM pay_us_rpt_totals WHERE attribute1='CSR';

1417:
1418: l_tag := '';
1419: DBMS_LOB.WRITEAPPEND(g_xml_data, length(l_tag), l_tag);
1420:
1421: DELETE FROM pay_us_rpt_totals WHERE attribute1='CSR';
1422:
1423: p_xml := g_xml_data;
1424:
1425: