DBA Data[Home] [Help]

APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on PAY_COST_ALLOCATIONS_F

Line 575: pay_cost_allocations_f CA

571: ASG1.payroll_id,
572: ASG1.organization_id,
573: CA.cost_allocation_keyflex_id
574: from per_all_assignments_f ASG1,
575: pay_cost_allocations_f CA
576: where ASG1.assignment_id = CA.assignment_id (+)
577: and ASG1.assignment_id = p_assignment_id
578: and nvl( CA.cost_allocation_id, -1) = nvl( p_cost_allocation_id, -1)
579: and p_effective_date between ASG1.effective_start_date

Line 593: from pay_cost_allocations_f CA2

589: where ASG3.assignment_id = p_assignment_id
590: and p_effective_date between ASG3.effective_start_date and ASG3.effective_end_date
591: and not exists (
592: select 'X'
593: from pay_cost_allocations_f CA2
594: where CA2.assignment_id = ASG3.assignment_id
595: and p_effective_date between CA2.effective_start_date and CA2.effective_end_date
596: )
597: ) ASG2