APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PER_ADDRESSES

Line 10684: per_addresses pa,

10680: pcn.city_code
10681: from pay_us_city_names pcn,
10682: pay_us_counties puc,
10683: pay_us_states pus,
10684: per_addresses pa,
10685: per_assignments_f paf
10686: where paf.assignment_id = p_assignment_id
10687: and p_effective_start_date between paf.effective_start_date and
10688: paf.effective_end_date

Line 11170: from per_addresses pa,

11166: /* rmonge fix bug 3429449 */
11167:
11168: cursor csr_addr_get_assignment(p_person number) is
11169: select paf.assignment_id, min(paf.effective_start_date)
11170: from per_addresses pa,
11171: hr_soft_coding_keyflex hsck,
11172: per_assignments_f paf
11173: where paf.person_id = p_person
11174: and paf.assignment_type = 'E'

Line 11193: from per_addresses pa,

11189: /* old cursor */
11190: /*
11191: cursor csr_addr_get_assignment(p_person number) is
11192: select paf.assignment_id, min(paf.effective_start_date)
11193: from per_addresses pa,
11194: hr_soft_coding_keyflex hsck,
11195: per_assignments_f paf
11196: where paf.person_id = p_person
11197: and paf.assignment_type = 'E'

Line 11218: from per_addresses pa,

11214: /* added a check for paf.effective_end_date for bug 1640913 */
11215:
11216: cursor csr_get_assignment(p_person number) is
11217: select paf.assignment_id, min(paf.effective_start_date)
11218: from per_addresses pa,
11219: hr_soft_coding_keyflex hsck,
11220: per_assignments_f paf
11221: where paf.person_id = p_person
11222: and paf.assignment_type = 'E'

Line 11239: from per_addresses pa,

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

Line 11260: from per_addresses pa,

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

Line 11292: per_addresses pa,

11288: pcn.city_code
11289: from pay_us_city_names pcn,
11290: pay_us_counties puc,
11291: pay_us_states pus,
11292: per_addresses pa,
11293: per_assignments_f paf
11294: where paf.assignment_id = p_assignment
11295: and p_effective_start_date between paf.effective_start_date and
11296: paf.effective_end_date

Line 11323: per_addresses pa,

11319: pcn.city_code
11320: from pay_us_city_names pcn,
11321: pay_us_counties puc,
11322: pay_us_states pus,
11323: per_addresses pa,
11324: per_assignments_f paf
11325: where paf.assignment_id = p_assignment
11326: and p_effective_start_date between paf.effective_start_date and
11327: paf.effective_end_date