DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PER_PEOPLE_F

Line 11240: per_people_f ppf,

11236:
11237: cursor csr_chk_assignment(p_assignment number, p_session_date date) is
11238: select 1
11239: from per_addresses pa,
11240: per_people_f ppf,
11241: hr_soft_coding_keyflex hsck,
11242: per_assignments_f paf
11243: where paf.assignment_id = p_assignment
11244: and p_session_date between paf.effective_start_date

Line 11261: per_people_f ppf,

11257:
11258: cursor csr_get_min_eff_date(p_assignment number) is
11259: select min(paf.effective_start_date)
11260: from per_addresses pa,
11261: per_people_f ppf,
11262: hr_soft_coding_keyflex hsck,
11263: per_assignments_f paf
11264: where paf.assignment_id = p_assignment
11265: and paf.soft_coding_keyflex_id is not null