APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_ALL_ASSIGNMENTS_F

Line 741: FROM per_all_assignments_f paf

737: -- BUG 4774784 fix end
738:
739: CURSOR get_person_id (l_assignment_id number,l_date_earned date) is
740: SELECT person_id
741: FROM per_all_assignments_f paf
742: WHERE paf.assignment_id = l_assignment_id
743: AND l_date_earned between paf.effective_start_date and paf.effective_end_date;
744:
745: CURSOR get_prim_assignment_id( l_person_id number,l_date date) is

Line 747: FROM per_all_assignments_f paf

743: AND l_date_earned between paf.effective_start_date and paf.effective_end_date;
744:
745: CURSOR get_prim_assignment_id( l_person_id number,l_date date) is
746: SELECT assignment_id
747: FROM per_all_assignments_f paf
748: WHERE paf.person_id = l_person_id
749: AND primary_flag = 'Y'
750: AND l_date between paf.effective_start_date and paf.effective_end_date;
751:

Line 823: per_all_assignments_f paa ,

819:
820: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
821: SELECT ORG_INFORMATION6 lu_tax_mun
822: FROM pay_assignment_actions assact ,
823: per_all_assignments_f paa ,
824: pay_payroll_actions ppa ,
825: hr_soft_coding_keyflex scl ,
826: hr_organization_information hoi
827: WHERE assact.assignment_action_id = p_assignment_action_id

Line 1021: FROM per_people_extra_info pei,per_all_assignments_f paf

1017:
1018: l_tax_period_rule VARCHAR2(80);
1019: cursor csr_people_extra_info is
1020: SELECT pei_information1
1021: FROM per_people_extra_info pei,per_all_assignments_f paf
1022: WHERE information_type = 'NO_FURTHER_PERIOD_DETAILS'
1023: AND paf.person_id = pei.person_id
1024: and paf.ASSIGNMENT_ID = p_assignment_id
1025: AND P_EFFECTIVE_DATE BETWEEN paf.EFFECTIVE_START_DATE