APPS.PQP_INI_BAL dependencies on PAY_US_RPT_TOTALS

Line 285: DELETE FROM pay_us_rpt_totals

281:
282: -- This is required during the second try, Suppose the adjustment went successful the second time
283: -- then we need to delete the error log entry that was created the first time
284: IF l_prev_upgrade_status = 'P' THEN
285: DELETE FROM pay_us_rpt_totals
286: WHERE business_group_id=g_sum_bal_info(1).business_group_id
287: AND state_name='CARMILEAGE_UPGRADE'
288: AND tax_unit_id = 250
289: AND location_id = g_sum_bal_info(1).assignment_id;

Line 313: -- Insert errored out details into pay_us_rpt_totals

309: upgrade_status := 'P'; --Partially Complete
310: END IF;
311: for i in 1..g_err_info.count
312: LOOP
313: -- Insert errored out details into pay_us_rpt_totals
314: -- This will be used during the second run.
315: INSERT INTO
316: pay_us_rpt_totals(
317: business_group_id

Line 316: pay_us_rpt_totals(

312: LOOP
313: -- Insert errored out details into pay_us_rpt_totals
314: -- This will be used during the second run.
315: INSERT INTO
316: pay_us_rpt_totals(
317: business_group_id
318: ,location_id
319: ,location_name
320: ,state_name

Line 1539: FROM pay_us_rpt_totals

1535: AND ppa.effective_date >= to_date('04/06/2003','MM/DD/YYYY')
1536: AND TRUNC(ppa.creation_date) < cp_effective_date
1537: AND (cp_patch_status='N'
1538: OR Exists(SELECT 'X'
1539: FROM pay_us_rpt_totals
1540: WHERE state_name = 'CARMILEAGE_UPGRADE'
1541: AND tax_unit_id=250
1542: AND location_id = paa.assignment_id
1543: AND business_group_id = p_business_group_id))