APPS.BEN_EXT_THREAD dependencies on PAY_US_RPT_TOTALS

Line 6864: DELETE FROM pay_us_rpt_totals

6860: --
6861: -- Delete the existing completed extracts for the extract def. within
6862: -- this business group.
6863: --
6864: DELETE FROM pay_us_rpt_totals
6865: WHERE tax_unit_id = p_conc_req_id
6866: AND attribute5 = 'EXTRACT_COMPLETED'
6867: AND business_group_id = p_business_group_id
6868: AND organization_id = p_business_group_id

Line 6893: INSERT INTO pay_us_rpt_totals

6889: IF l_ext_type IN
6890: ('PEN_FPR', 'PEN_CHG', 'FID_PTC','FID_CAC',
6891: 'FID_ERC', 'FID_LPY', 'FID_ATE','FID_CHG') THEN
6892:
6893: INSERT INTO pay_us_rpt_totals
6894: (session_id -- session id
6895: ,organization_name -- Conc. Program Name
6896: ,business_group_id -- business group id
6897: ,organization_id -- -do-

Line 6934: INSERT INTO pay_us_rpt_totals

6930: );
6931: ELSIF l_ext_type IN
6932: ('GBL_FPR', 'GBL_CHG', 'GBL_MUL_CHG') THEN
6933:
6934: INSERT INTO pay_us_rpt_totals
6935: (session_id -- session id
6936: ,organization_name -- Conc. Program Name
6937: ,business_group_id -- business group id
6938: ,organization_id -- -do-

Line 7054: -- of the extract parameters of the failed run into table pay_us_rpt_totals.

7050: end if ;
7051: --
7052: -- Check to see if the extract being re-started is a PQP US/Global seeded
7053: -- or copied extract, if yes then the following procedure insert the values
7054: -- of the extract parameters of the failed run into table pay_us_rpt_totals.
7055: --
7056: Chk_PQP_Extract
7057: (p_ext_dfn_id => p_ext_dfn_id
7058: ,p_ext_rslt_id => l_ext_rslt_id