APPS.BEN_EXT_THREAD dependencies on PAY_US_RPT_TOTALS

Line 6905: DELETE FROM pay_us_rpt_totals

6901: --
6902: -- Delete the existing completed extracts for the extract def. within
6903: -- this business group.
6904: --
6905: DELETE FROM pay_us_rpt_totals
6906: WHERE tax_unit_id = p_conc_req_id
6907: AND attribute5 = 'EXTRACT_COMPLETED'
6908: AND business_group_id = p_business_group_id
6909: AND organization_id = p_business_group_id

Line 6934: INSERT INTO pay_us_rpt_totals

6930: IF l_ext_type IN
6931: ('PEN_FPR', 'PEN_CHG', 'FID_PTC','FID_CAC',
6932: 'FID_ERC', 'FID_LPY', 'FID_ATE','FID_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 6975: INSERT INTO pay_us_rpt_totals

6971: );
6972: ELSIF l_ext_type IN
6973: ('GBL_FPR', 'GBL_CHG', 'GBL_MUL_CHG') THEN
6974:
6975: INSERT INTO pay_us_rpt_totals
6976: (session_id -- session id
6977: ,organization_name -- Conc. Program Name
6978: ,business_group_id -- business group id
6979: ,organization_id -- -do-

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

7091: end if ;
7092: --
7093: -- Check to see if the extract being re-started is a PQP US/Global seeded
7094: -- or copied extract, if yes then the following procedure insert the values
7095: -- of the extract parameters of the failed run into table pay_us_rpt_totals.
7096: --
7097: Chk_PQP_Extract
7098: (p_ext_dfn_id => p_ext_dfn_id
7099: ,p_ext_rslt_id => l_ext_rslt_id