APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_US_RPT_TOTALS

Line 1911: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);

1907: -- END IF; --assignment action ID
1908: END IF;
1909: CLOSE cur_valid_asg_act;
1910:
1911: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);
1912: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);
1913:
1914: INSERT INTO PAY_US_RPT_TOTALS
1915: (BUSINESS_GROUP_ID

Line 1914: INSERT INTO PAY_US_RPT_TOTALS

1910:
1911: hr_utility.set_location(' Before Inserting PAY_US_RPT_TOTALS', 890);
1912: hr_utility.set_location(' VALUE OF EMP_CATG'||l_valid_asg_rec.EMP_CATG, 890);
1913:
1914: INSERT INTO PAY_US_RPT_TOTALS
1915: (BUSINESS_GROUP_ID
1916: ,ATTRIBUTE1 --payroll_action_id
1917: ,ATTRIBUTE2 --Assignment_id
1918: ,ATTRIBUTE3 --EHECS_CATG M(Managers)/C(Clerk)/P(Production Wrk)

Line 1989: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);

1985: ,l_rac_er_bal_val
1986: ,l_al_bal_val -- 6856473
1987: );
1988:
1989: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1990:
1991: CLOSE cur_valid_asg;
1992:
1993: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);

Line 2291: FROM PAY_US_RPT_TOTALS

2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2291: FROM PAY_US_RPT_TOTALS
2292: WHERE ATTRIBUTE1 = to_char(c_pact_id)
2293: AND ATTRIBUTE3 IS NOT NULL
2294: AND ATTRIBUTE4 IS NOT NULL
2295: GROUP BY ATTRIBUTE3, ATTRIBUTE4