APPS.PAY_BALANCE_UPLOAD dependencies on PAY_TEMP_BALANCE_ADJUSTMENTS

Line 1347: -- temporary DB table caled PAY_TEMP_BALANCE_ADJUSTMENTS.

1343: -- contribute to the current amount.
1344: -- USES
1345: -- NOTES
1346: -- The list of balance adjustments for the assignment are held in a
1347: -- temporary DB table caled PAY_TEMP_BALANCE_ADJUSTMENTS.
1348: -----------------------------------------------------------------------------
1349: --
1350: procedure get_current_value
1351: (

Line 1393: from pay_temp_balance_adjustments BA

1389: ) is
1390: select
1391: nvl(sum(BA.adjustment_amount), 0)
1392: ,nvl(min(BA.adjustment_date), p_upload_date)
1393: from pay_temp_balance_adjustments BA
1394: where BA.balance_type_id = p_balance_type_id
1395: and BA.adjustment_date between p_expiry_date
1396: and p_upload_date
1397: and ((p_batch_line_rec.jurisdiction_code is null) or

Line 1757: insert into pay_temp_balance_adjustments

1753: -- Add new balance adjustment to the list NB. if the existing balance
1754: -- adjustments already add up to the correct amount for the initial balance
1755: -- then do not create a new balance adjustment.
1756: --
1757: insert into pay_temp_balance_adjustments
1758: (batch_line_id
1759: ,balance_type_id
1760: ,balance_dimension_id
1761: ,expiry_date

Line 2087: from pay_temp_balance_adjustments TBA

2083: --
2084: cursor csr_bal_adj is
2085: select TBA.*
2086: ,ASG.payroll_id
2087: from pay_temp_balance_adjustments TBA
2088: ,per_all_assignments_f ASG
2089: where
2090: ASG.assignment_id = p_glbl_data_rec.assignment_id
2091: and TBA.adjustment_date between ASG.effective_start_date

Line 5059: from pay_temp_balance_adjustments TBA1,

5055: --
5056: cursor csr_conflicts
5057: is
5058: select distinct TBA1.batch_line_id
5059: from pay_temp_balance_adjustments TBA1,
5060: pay_temp_balance_adjustments TBA2,
5061: pay_balance_types BT
5062: where TBA1.batch_line_id <> TBA2.batch_line_id
5063: and TBA1.adjustment_date = TBA2.adjustment_date

Line 5060: pay_temp_balance_adjustments TBA2,

5056: cursor csr_conflicts
5057: is
5058: select distinct TBA1.batch_line_id
5059: from pay_temp_balance_adjustments TBA1,
5060: pay_temp_balance_adjustments TBA2,
5061: pay_balance_types BT
5062: where TBA1.batch_line_id <> TBA2.batch_line_id
5063: and TBA1.adjustment_date = TBA2.adjustment_date
5064: and TBA1.balance_type_id = TBA2.balance_type_id

Line 5179: delete from pay_temp_balance_adjustments;

5175: g_payroll_actions.delete(l_payroll_action_num+1,g_payroll_actions.count);
5176: end if;
5177: --
5178: --
5179: delete from pay_temp_balance_adjustments;
5180: --
5181: hr_utility.trace('Exiting pay_balance_upload.transfer_assignment');
5182: --
5183: -- The transfer has failed.

Line 5227: delete from pay_temp_balance_adjustments;

5223: where BL.batch_line_id = l_batch_line_list(l_index);
5224: --
5225: end loop;
5226: --
5227: delete from pay_temp_balance_adjustments;
5228: --
5229: when others then
5230: --
5231: hr_utility.trace(sqlerrm);

Line 5268: delete from pay_temp_balance_adjustments;

5264: where BL.batch_line_id = l_batch_line_list(l_index);
5265: --
5266: end loop;
5267: --
5268: delete from pay_temp_balance_adjustments;
5269: --
5270: end transfer_assignment;
5271: --
5272: -----------------------------------------------------------------------------