APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_ALL_ASSIGNMENTS_F

Line 719: FROM per_all_assignments_f paf

715: -- BUG 4774784 fix end
716:
717: CURSOR get_person_id (l_assignment_id number,l_date_earned date) is
718: SELECT person_id
719: FROM per_all_assignments_f paf
720: WHERE paf.assignment_id = l_assignment_id
721: AND l_date_earned between paf.effective_start_date and paf.effective_end_date;
722:
723: CURSOR get_prim_assignment_id( l_person_id number,l_date date) is

Line 725: FROM per_all_assignments_f paf

721: AND l_date_earned between paf.effective_start_date and paf.effective_end_date;
722:
723: CURSOR get_prim_assignment_id( l_person_id number,l_date date) is
724: SELECT assignment_id
725: FROM per_all_assignments_f paf
726: WHERE paf.person_id = l_person_id
727: AND primary_flag = 'Y'
728: AND l_date between paf.effective_start_date and paf.effective_end_date;
729:

Line 801: per_all_assignments_f paa ,

797:
798: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
799: SELECT ORG_INFORMATION6 lu_tax_mun
800: FROM pay_assignment_actions assact ,
801: per_all_assignments_f paa ,
802: pay_payroll_actions ppa ,
803: hr_soft_coding_keyflex scl ,
804: hr_organization_information hoi
805: WHERE assact.assignment_action_id = p_assignment_action_id