APPS.PAY_BALANCE_UPLOAD dependencies on PAY_TEMP_BALANCE_ADJUSTMENTS

Line 1349: -- temporary DB table caled PAY_TEMP_BALANCE_ADJUSTMENTS.

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

Line 1395: from pay_temp_balance_adjustments BA

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

Line 1759: insert into pay_temp_balance_adjustments

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

Line 2338: from pay_temp_balance_adjustments TBA

2334: --
2335: cursor csr_bal_adj is
2336: select TBA.*
2337: ,ASG.payroll_id
2338: from pay_temp_balance_adjustments TBA
2339: ,per_all_assignments_f ASG
2340: where
2341: ASG.assignment_id = p_glbl_data_rec.assignment_id
2342: and TBA.adjustment_date between ASG.effective_start_date

Line 5352: from pay_temp_balance_adjustments TBA1,

5348: --
5349: cursor csr_conflicts
5350: is
5351: select distinct TBA1.batch_line_id
5352: from pay_temp_balance_adjustments TBA1,
5353: pay_temp_balance_adjustments TBA2,
5354: pay_balance_types BT
5355: where TBA1.batch_line_id <> TBA2.batch_line_id
5356: and TBA1.adjustment_date = TBA2.adjustment_date

Line 5353: pay_temp_balance_adjustments TBA2,

5349: cursor csr_conflicts
5350: is
5351: select distinct TBA1.batch_line_id
5352: from pay_temp_balance_adjustments TBA1,
5353: pay_temp_balance_adjustments TBA2,
5354: pay_balance_types BT
5355: where TBA1.batch_line_id <> TBA2.batch_line_id
5356: and TBA1.adjustment_date = TBA2.adjustment_date
5357: and TBA1.balance_type_id = TBA2.balance_type_id

Line 5472: delete from pay_temp_balance_adjustments;

5468: g_payroll_actions.delete(l_payroll_action_num+1,g_payroll_actions.count);
5469: end if;
5470: --
5471: --
5472: delete from pay_temp_balance_adjustments;
5473: --
5474: hr_utility.trace('Exiting pay_balance_upload.transfer_assignment');
5475: --
5476: -- The transfer has failed.

Line 5520: delete from pay_temp_balance_adjustments;

5516: where BL.batch_line_id = l_batch_line_list(l_index);
5517: --
5518: end loop;
5519: --
5520: delete from pay_temp_balance_adjustments;
5521: --
5522: when others then
5523: --
5524: hr_utility.trace(sqlerrm);

Line 5561: delete from pay_temp_balance_adjustments;

5557: where BL.batch_line_id = l_batch_line_list(l_index);
5558: --
5559: end loop;
5560: --
5561: delete from pay_temp_balance_adjustments;
5562: --
5563: end transfer_assignment;
5564: --
5565: -----------------------------------------------------------------------------