APPS.PQP_EXCP_RPT dependencies on PAY_US_RPT_TOTALS

Line 17: -- Cursor to get the row from the pay_us_rpt_totals table

13: )
14: IS
15:
16: --
17: -- Cursor to get the row from the pay_us_rpt_totals table
18: --
19: CURSOR c_exception_report_data IS
20: SELECT
21: fnd_number.canonical_to_number(purt.business_group_id) business_group_id,

Line 38: FROM pay_us_rpt_totals purt

34: purt.attribute10 middle_name,
35: purt.attribute9 national_id,
36: purt.attribute11 effective_date,
37: purt.attribute13 assignment_number
38: FROM pay_us_rpt_totals purt
39: WHERE organization_id=p_ppa_finder
40: AND purt.attribute12 = p_ppa_finder
41: ORDER BY purt.attribute7;
42: -- End of Cursor

Line 311: -- Loop for all the rows found in the pay_us_rpt_totals table

307: l_report_id_old := -1;
308: l_header_printed := FALSE;
309:
310: --
311: -- Loop for all the rows found in the pay_us_rpt_totals table
312: --
313: FOR r_excp_rpt_data IN c_exception_report_data
314: LOOP
315:

Line 566: DELETE FROM pay_us_rpt_totals

562:
563: END LOOP;
564: -- Loop Ends here
565: IF l_output_format = 'CSV' THEN
566: DELETE FROM pay_us_rpt_totals
567: WHERE organization_id =p_ppa_finder
568: AND attribute12 = p_ppa_finder;
569: commit;
570: hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');

Line 570: hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');

566: DELETE FROM pay_us_rpt_totals
567: WHERE organization_id =p_ppa_finder
568: AND attribute12 = p_ppa_finder;
569: commit;
570: hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');
571: END IF;
572:
573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN