APPS.PAY_US_PR_W2 dependencies on PAY_US_RPT_TOTALS

Line 731: FROM pay_us_rpt_totals

727: sum(value14) med_tax,
728: sum(value15) ss_tips,
729: sum(value16) ss_tax_on_tips,
730: sum(value17) med_tax_on_tips
731: FROM pay_us_rpt_totals
732: WHERE attribute2 = p_report_type
733: AND session_id = to_number(p_seq_num)
734: GROUP BY attribute8,attribute9, attribute11,attribute12,attribute13,attribute14,attribute15,attribute16,attribute17,attribute10;
735:

Line 781: FROM pay_us_rpt_totals

777: value14 med_tax,
778: value15 ss_tips,
779: value16 ss_tax_on_tips,
780: value17 med_tax_on_tips
781: FROM pay_us_rpt_totals
782: WHERE attribute2 = p_report_type
783: AND session_id = to_number(p_seq_num);
784:
785: TYPE numeric_table IS TABLE OF number(20,2)

Line 1084: FROM pay_us_rpt_totals

1080:
1081: /*
1082: select count(*)
1083: into ln_count
1084: FROM pay_us_rpt_totals
1085: WHERE attribute2 = 'PRW2REGISTER'
1086: AND session_id = to_number(p_seq_num);
1087:
1088: hr_utility.trace('Total# of Records ='||to_char(ln_count));

Line 1090: DELETE from pay_us_rpt_totals

1086: AND session_id = to_number(p_seq_num);
1087:
1088: hr_utility.trace('Total# of Records ='||to_char(ln_count));
1089: */
1090: DELETE from pay_us_rpt_totals
1091: WHERE attribute2 = 'PRW2REGISTER'
1092: AND session_id = to_number(p_seq_num);
1093:
1094: end if;

Line 1263: FROM pay_us_rpt_totals

1259:
1260: /*
1261: select count(*)
1262: into ln_count
1263: FROM pay_us_rpt_totals
1264: WHERE attribute2 = p_report_type
1265: AND session_id = to_number(p_seq_num);
1266:
1267: hr_utility.trace('Total# of Records ='||to_char(ln_count));

Line 1269: DELETE FROM pay_us_rpt_totals

1265: AND session_id = to_number(p_seq_num);
1266:
1267: hr_utility.trace('Total# of Records ='||to_char(ln_count));
1268: */
1269: DELETE FROM pay_us_rpt_totals
1270: WHERE attribute2 = p_report_type
1271: AND session_id = to_number(p_seq_num);
1272:
1273: end if;