APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_US_RPT_TOTALS

Line 1037: insert into pay_us_rpt_totals

1033: set serial_number = lv_serial_number
1034: where assignment_action_id = ln_adj_action_id;
1035:
1036: hr_utility.trace('Insert into temp table ');
1037: insert into pay_us_rpt_totals
1038: (location_id, organization_id, tax_unit_id,
1039: value1, value3)
1040: select
1041: p_payroll_action_id,

Line 1048: (select 1 from pay_us_rpt_totals

1044: ln_run_consolidation_id,
1045: ln_adj_business_group_id
1046: from dual
1047: where not exists
1048: (select 1 from pay_us_rpt_totals
1049: where location_id = p_payroll_action_id
1050: and tax_unit_id = ln_run_payroll_id
1051: and value1 = ln_run_consolidation_id
1052: and organization_id

Line 1110: from pay_us_rpt_totals prt

1106: select prt.rowid,
1107: to_date(lpad(to_char(prt.organization_id),8,'0'),'ddmmyyyy'),
1108: tax_unit_id,
1109: value1
1110: from pay_us_rpt_totals prt
1111: where prt.location_id = cp_payroll_action_id
1112: and prt.value2 is null
1113: order by to_date(lpad(to_char(prt.organization_id),8,'0'),'ddmmyyyy'),
1114: tax_unit_id, value1;

Line 1131: /* Check the pay_action_infor table to see if the pay_us_rpt_totals

1127: ld_run_prv_effective_date := to_date('1800/01/01', 'yyyy/mm/dd');
1128: ln_run_prv_payroll_id := -1;
1129: ln_run_prv_consolidation_id := -1;
1130:
1131: /* Check the pay_action_infor table to see if the pay_us_rpt_totals
1132: ** has been cleaned up and payroll actions for them started.
1133: ** If the status is not 'C' then it could mean -
1134: ** 1) this is the first time it has been called
1135: ** 2) the first assignment action for the chunk has errored

Line 1182: update pay_us_rpt_totals

1178: p_batch_mode => 'STANDARD',
1179: p_effective_date => ld_run_effective_date,
1180: p_consolidation_set_id => ln_run_consolidation_id,
1181: p_prepay_flag => 'N');
1182: update pay_us_rpt_totals
1183: set value2 = ln_payroll_action_id
1184: where rowid = lr_rowid;
1185: else
1186: hr_utility.set_location(gv_package || lv_procedure_name, 50);

Line 1187: delete from pay_us_rpt_totals

1183: set value2 = ln_payroll_action_id
1184: where rowid = lr_rowid;
1185: else
1186: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1187: delete from pay_us_rpt_totals
1188: where rowid = lr_rowid;
1189: end if;
1190: end loop;
1191: close c_get_adj_dates;

Line 1339: from pay_us_rpt_totals prt

1335: ln_badj_payroll_Action_id NUMBER;
1336:
1337: cursor c_get_badj_payroll_action (cp_payroll_action_id in number) is
1338: select prt.value2
1339: from pay_us_rpt_totals prt
1340: where prt.location_id = cp_payroll_action_id;
1341:
1342: BEGIN
1343:

Line 1367: delete from pay_us_rpt_totals

1363: end loop;
1364: close c_get_badj_payroll_action;
1365:
1366:
1367: delete from pay_us_rpt_totals
1368: where location_id = p_payroll_action_id;
1369:
1370: delete from pay_action_information
1371: where ACTION_CONTEXT_ID = p_payroll_action_id

Line 1422: from pay_us_rpt_totals prt

1418: ,cp_run_payroll_id in number
1419: ,cp_consolidation_id in number) IS
1420: select value2 badj_payroll_Action,
1421: value3 business_group_id
1422: from pay_us_rpt_totals prt
1423: where prt.location_id = cp_payroll_action_id
1424: and to_date(lpad(to_char(prt.organization_id),8,'0'),'ddmmyyyy')
1425: = cp_badj_effective_date
1426: and tax_unit_id = cp_run_payroll_id

Line 1544: -- The data in pay_us_rpt_totals has been cleanup, so start

1540: p_chunk_number => l_chunk_number);
1541: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1542:
1543: --
1544: -- The data in pay_us_rpt_totals has been cleanup, so start
1545: -- the balance adjustment process
1546: lv_sit_adj_flag := 'N';
1547: lv_sdi_adj_flag := 'N';
1548: ln_step := 1;