DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on PER_ALL_ASSIGNMENTS_F

Line 640: per_all_assignments_f paaf_current,

636:
637: select distinct paa_other.assignment_id,
638: paa_other.assignment_action_id
639: from pay_assignment_actions paa_current,
640: per_all_assignments_f paaf_current,
641: pay_assignment_actions paa_other,
642: per_all_assignments_f paaf_other
643: where paa_current.payroll_action_id = c_arch_pay_action_id
644: and paa_current.assignment_action_id = c_arch_asg_action_id

Line 642: per_all_assignments_f paaf_other

638: paa_other.assignment_action_id
639: from pay_assignment_actions paa_current,
640: per_all_assignments_f paaf_current,
641: pay_assignment_actions paa_other,
642: per_all_assignments_f paaf_other
643: where paa_current.payroll_action_id = c_arch_pay_action_id
644: and paa_current.assignment_action_id = c_arch_asg_action_id
645: and paaf_current.assignment_id = paa_current.assignment_id
646: and paa_other.payroll_action_id = c_arch_pay_action_id

Line 1621: per_all_assignments_f paaf

1617: cursor csr_asg (c_arch_payroll_action_id number) is
1618: select distinct paa.assignment_id
1619: from pay_assignment_actions paa,
1620: pay_action_information pai,
1621: per_all_assignments_f paaf
1622: where paa.payroll_action_id = c_arch_payroll_action_id
1623: and pai.action_context_id = paa.assignment_action_id
1624: and pai.action_information_category = 'GB_RTI_FPS_ASG_DET1'
1625: and pai.action_context_type = 'AAP'