DBA Data[Home] [Help]

APPS.PAY_GB_RTI_OUTPUT dependencies on PER_ALL_ASSIGNMENTS_F

Line 606: per_all_assignments_f paaf_current,

602:
603: select distinct paa_other.assignment_id,
604: paa_other.assignment_action_id
605: from pay_assignment_actions paa_current,
606: per_all_assignments_f paaf_current,
607: pay_assignment_actions paa_other,
608: per_all_assignments_f paaf_other
609: where paa_current.payroll_action_id = c_arch_pay_action_id
610: and paa_current.assignment_action_id = c_arch_asg_action_id

Line 608: per_all_assignments_f paaf_other

604: paa_other.assignment_action_id
605: from pay_assignment_actions paa_current,
606: per_all_assignments_f paaf_current,
607: pay_assignment_actions paa_other,
608: per_all_assignments_f paaf_other
609: where paa_current.payroll_action_id = c_arch_pay_action_id
610: and paa_current.assignment_action_id = c_arch_asg_action_id
611: and paaf_current.assignment_id = paa_current.assignment_id
612: and paa_other.payroll_action_id = c_arch_pay_action_id

Line 1144: per_all_assignments_f paaf

1140: cursor csr_asg (c_arch_payroll_action_id number) is
1141: select distinct paa.assignment_id
1142: from pay_assignment_actions paa,
1143: pay_action_information pai,
1144: per_all_assignments_f paaf
1145: where paa.payroll_action_id = c_arch_payroll_action_id
1146: and pai.action_context_id = paa.assignment_action_id
1147: -- and pai.action_information_category = 'GB_RTI_ASG_DETAILS'
1148: and pai.action_information_category = 'GB RTI EMPLOYEE DETAILS'