APPS.PAY_BALANCE_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 1622: from per_all_assignments_f ASS

1618: p_assignment_id number
1619: ,p_effective_date date
1620: ) is
1621: select ASS.payroll_id
1622: from per_all_assignments_f ASS
1623: where ASS.assignment_id = p_assignment_id
1624: and p_effective_date between ASS.effective_start_date
1625: and ASS.effective_end_date;
1626: --

Line 2088: ,per_all_assignments_f ASG

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
2092: and ASG.effective_end_date

Line 3189: from per_all_assignments_f

3185: --
3186: -- get bus grp id
3187: select distinct person_id,business_group_id
3188: into l_person_id,l_bus_grp_id
3189: from per_all_assignments_f
3190: where assignment_id = p_assignment_id;
3191:
3192: pay_core_utils.get_upgrade_status(p_bus_grp_id=> l_bus_grp_id,
3193: p_short_name=> 'SINGLE_BAL_TABLE',

Line 4561: from per_all_assignments_f ASG

4557: ,ASG.assignment_type
4558: ,ASG.business_group_id
4559: ,ASG.payroll_id
4560: ,ASG.effective_start_date
4561: from per_all_assignments_f ASG
4562: where p_assignment_id is not null
4563: and ASG.business_group_id + 0 = p_business_group_id
4564: and ASG.assignment_id = p_assignment_id
4565: and p_upload_date between ASG.effective_start_date

Line 4574: from per_all_assignments_f ASG

4570: ,ASG.assignment_type
4571: ,ASG.business_group_id
4572: ,ASG.payroll_id
4573: ,ASG.effective_start_date
4574: from per_all_assignments_f ASG
4575: where p_assignment_id is null
4576: and ASG.business_group_id + 0 = p_business_group_id
4577: and ASG.assignment_number = p_assignment_number
4578: and p_upload_date between ASG.effective_start_date

Line 5305: per_all_assignments_f ASG

5301: select /*+ ORDERED
5302: INDEX(ASG PER_ASSIGNMENTS_F_PK)*/
5303: distinct ASG.assignment_id
5304: from pay_balance_batch_lines BL,
5305: per_all_assignments_f ASG
5306: where BL.batch_id = p_batch_id
5307: and BL.assignment_id = ASG.assignment_id
5308: and ASG.business_group_id = p_business_group_id
5309: and ASG.payroll_id + 0 = p_payroll_id

Line 5641: per_all_assignments_f ASG

5637: select /*+ ORDERED
5638: INDEX(ASG PER_ASSIGNMENTS_F_PK)*/
5639: distinct ASG.assignment_id
5640: from pay_balance_batch_lines BL,
5641: per_all_assignments_f ASG
5642: where BL.batch_id = p_batch_id
5643: and BL.assignment_id = ASG.assignment_id
5644: and BL.batch_line_status = 'T'
5645: and ASG.business_group_id = p_business_group_id