DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PER_PEOPLE_F

Line 11316: per_people_f ppf,

11312:
11313: cursor csr_chk_assignment(p_assignment number, p_session_date date) is
11314: select 1
11315: from per_addresses pa,
11316: per_people_f ppf,
11317: hr_soft_coding_keyflex hsck,
11318: per_assignments_f paf
11319: where paf.assignment_id = p_assignment
11320: and p_session_date between paf.effective_start_date

Line 11337: per_people_f ppf,

11333:
11334: cursor csr_get_min_eff_date(p_assignment number) is
11335: select min(paf.effective_start_date)
11336: from per_addresses pa,
11337: per_people_f ppf,
11338: hr_soft_coding_keyflex hsck,
11339: per_assignments_f paf
11340: where paf.assignment_id = p_assignment
11341: and paf.soft_coding_keyflex_id is not null