APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PER_ADDRESSES

Line 10760: per_addresses pa,

10756: pcn.city_code
10757: from pay_us_city_names pcn,
10758: pay_us_counties puc,
10759: pay_us_states pus,
10760: per_addresses pa,
10761: per_assignments_f paf
10762: where paf.assignment_id = p_assignment_id
10763: and p_effective_start_date between paf.effective_start_date and
10764: paf.effective_end_date

Line 11246: from per_addresses pa,

11242: /* rmonge fix bug 3429449 */
11243:
11244: cursor csr_addr_get_assignment(p_person number) is
11245: select paf.assignment_id, min(paf.effective_start_date)
11246: from per_addresses pa,
11247: hr_soft_coding_keyflex hsck,
11248: per_assignments_f paf
11249: where paf.person_id = p_person
11250: and paf.assignment_type = 'E'

Line 11269: from per_addresses pa,

11265: /* old cursor */
11266: /*
11267: cursor csr_addr_get_assignment(p_person number) is
11268: select paf.assignment_id, min(paf.effective_start_date)
11269: from per_addresses pa,
11270: hr_soft_coding_keyflex hsck,
11271: per_assignments_f paf
11272: where paf.person_id = p_person
11273: and paf.assignment_type = 'E'

Line 11294: from per_addresses pa,

11290: /* added a check for paf.effective_end_date for bug 1640913 */
11291:
11292: cursor csr_get_assignment(p_person number) is
11293: select paf.assignment_id, min(paf.effective_start_date)
11294: from per_addresses pa,
11295: hr_soft_coding_keyflex hsck,
11296: per_assignments_f paf
11297: where paf.person_id = p_person
11298: and paf.assignment_type = 'E'

Line 11315: from per_addresses pa,

11311: does not necessarily have to be a primary assignment */
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

Line 11336: from per_addresses pa,

11332: the defaulting criteria has been satisfied */
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

Line 11368: per_addresses pa,

11364: pcn.city_code
11365: from pay_us_city_names pcn,
11366: pay_us_counties puc,
11367: pay_us_states pus,
11368: per_addresses pa,
11369: per_assignments_f paf
11370: where paf.assignment_id = p_assignment
11371: and p_effective_start_date between paf.effective_start_date and
11372: paf.effective_end_date

Line 11399: per_addresses pa,

11395: pcn.city_code
11396: from pay_us_city_names pcn,
11397: pay_us_counties puc,
11398: pay_us_states pus,
11399: per_addresses pa,
11400: per_assignments_f paf
11401: where paf.assignment_id = p_assignment
11402: and p_effective_start_date between paf.effective_start_date and
11403: paf.effective_end_date