APPS.PAY_MX_FORMAT_2D dependencies on PAY_US_RPT_TOTALS

Line 778: FROM pay_us_rpt_totals

774: ln_session_id := USERENV('sessionid');
775:
776: SELECT COUNT(*)
777: INTO ln_count
778: FROM pay_us_rpt_totals
779: WHERE tax_unit_id = ln_payroll_action_id
780: AND session_id = ln_session_id;
781:
782:

Line 785: INSERT INTO pay_us_rpt_totals ( session_id

781:
782:
783: IF ln_count = 0 THEN
784:
785: INSERT INTO pay_us_rpt_totals ( session_id
786: ,business_group_id
787: ,tax_unit_id
788: ,organization_name )
789: VALUES ( ln_session_id

Line 798: UPDATE pay_us_rpt_totals

794: END IF;
795:
796: IF lv_level = '1' THEN
797:
798: UPDATE pay_us_rpt_totals
799: SET value1 = NVL(value1,0) + 1 -- No. of Employees
800: ,value6 = NVL(value6,0) + prev_format2d.SAL_WAGES
801: ,value11 = NVL(value11,0) + prev_format2d.OVERTIME
802: ,value16 = NVL(value16,0) + prev_format2d.PROFIT_SHARING

Line 819: UPDATE pay_us_rpt_totals

815: AND session_id = ln_session_id;
816:
817: ELSIF lv_level = '2' THEN
818:
819: UPDATE pay_us_rpt_totals
820: SET value2 = NVL(value2,0) + 1 -- No. of Employees
821: ,value7 = NVL(value7,0) + prev_format2d.SAL_WAGES
822: ,value12 = NVL(value12,0) + prev_format2d.OVERTIME
823: ,value17 = NVL(value17,0) + prev_format2d.PROFIT_SHARING

Line 841: UPDATE pay_us_rpt_totals

837:
838:
839: ELSIF lv_level = '3' THEN
840:
841: UPDATE pay_us_rpt_totals
842: SET value3 = NVL(value3,0) + 1 -- No. of Employees
843: ,value8 = NVL(value8,0) + prev_format2d.SAL_WAGES
844: ,value13 = NVL(value13,0) + prev_format2d.OVERTIME
845: ,value18 = NVL(value18,0) + prev_format2d.PROFIT_SHARING

Line 863: UPDATE pay_us_rpt_totals

859:
860:
861: ELSIF lv_level = '4' THEN
862:
863: UPDATE pay_us_rpt_totals
864: SET value4 = NVL(value4,0) + 1 -- No. of Employees
865: ,value9 = NVL(value9,0) + prev_format2d.SAL_WAGES
866: ,value14 = NVL(value14,0) + prev_format2d.OVERTIME
867: ,value19 = NVL(value19,0) + prev_format2d.PROFIT_SHARING

Line 885: UPDATE pay_us_rpt_totals

881:
882:
883: ELSIF lv_level = '5' THEN
884:
885: UPDATE pay_us_rpt_totals
886: SET value5 = NVL(value5,0) + 1 -- No. of Employees
887: ,value10 = NVL(value10,0) + prev_format2d.SAL_WAGES
888: ,value15 = NVL(value15,0) + prev_format2d.OVERTIME
889: ,value20 = NVL(value20,0) + prev_format2d.PROFIT_SHARING

Line 1004: FROM pay_us_rpt_totals

1000: ,NVL(SUM(attribute22),0) TOTAL_EARNINGS_280066
1001: ,NVL(SUM(attribute23),0) TOTAL_EARNINGS_280076
1002: ,NVL(SUM(attribute24),0) TOTAL_EARNINGS_280086
1003: ,NVL(SUM(attribute25),0) TOTAL_EARNINGS_280096
1004: FROM pay_us_rpt_totals
1005: WHERE tax_unit_id = cp_payroll_action_id
1006: GROUP by organization_name;
1007:
1008: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;

Line 1155: DELETE FROM pay_us_rpt_totals

1151: 2);
1152:
1153: write_to_magtape_lob (lv_buf);
1154:
1155: DELETE FROM pay_us_rpt_totals
1156: WHERE tax_unit_id = ln_payroll_action_id;
1157:
1158:
1159: hr_utility_trace ('Leaving '||l_proc_name);