DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_PEOPLE_EXTRA_INFO

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