DBA Data[Home] [Help]

APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 574: from per_all_assignments_f ASG1,

570: select ASG1.assignment_id,
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)

Line 588: from per_all_assignments_f ASG3

584: select to_number(ASG3.assignment_id) assignment_id,
585: to_number(ASG3.payroll_id) payroll_id,
586: to_number(ASG3.organization_id) organization_id,
587: to_number(null) cost_allocation_keyflex_id
588: from per_all_assignments_f ASG3
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'

Line 652: per_all_assignments_f ASG

648: pay_cost_allocation_keyflex P,
649: pay_element_links_f EL,
650: pay_payrolls_f PP,
651: pay_element_entries_f EE,
652: per_all_assignments_f ASG
653: where ASG.assignment_id = EE.assignment_id
654: and ASG.assignment_id = p_assignment_id
655: and EE.element_link_id = EL.element_link_id
656: and EE.element_entry_id = p_element_entry_id