[Home] [Help]
5487:
5488:
5489: cursor csr_get_asg_gre (p_assignment number)is
5490: select hsck.segment1
5491: from hr_soft_coding_keyflex hsck,
5492: per_assignments_f paf
5493: where paf.assignment_id = p_assignment
5494: and p_effective_start_date between paf.effective_start_date
5495: and paf.effective_end_date
6139:
6140: cursor c_tax_unit_id(p_assignment_id in number,
6141: p_session_date in date) is
6142: select to_number(segment1) tax_unit_id
6143: from hr_soft_coding_keyflex a,
6144: per_assignments_f b
6145: where b.assignment_id = p_assignment_id
6146: and b.soft_coding_keyflex_id = a.soft_coding_keyflex_id
6147: and p_session_date between b.effective_start_date and b.effective_end_date ;
7684: and rownum < 2;
7685:
7686: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
7687: select nvl(hsck.segment18, paf.location_id)
7688: from HR_SOFT_CODING_KEYFLEX hsck,
7689: PER_ASSIGNMENTS_F paf
7690: where paf.assignment_id = p_assignment
7691: and p_session_dt between paf.effective_start_date
7692: and paf.effective_end_date
8003: and rownum < 2;
8004:
8005: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
8006: select nvl(hsck.segment18, paf.location_id)
8007: from HR_SOFT_CODING_KEYFLEX hsck,
8008: PER_ASSIGNMENTS_F paf
8009: where paf.assignment_id = p_assignment
8010: and p_session_dt between paf.effective_start_date
8011: and paf.effective_end_date
9031: and rownum < 2;
9032:
9033: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
9034: select nvl(hsck.segment18, paf.location_id)
9035: from HR_SOFT_CODING_KEYFLEX hsck,
9036: PER_ASSIGNMENTS_F paf
9037: where paf.assignment_id = p_assignment
9038: and p_session_dt between paf.effective_start_date
9039: and paf.effective_end_date
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'
11175: and paf.soft_coding_keyflex_id is not null
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'
11198: and paf.soft_coding_keyflex_id is not null
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'
11223: and paf.soft_coding_keyflex_id is not null
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
11245: and paf.effective_end_date
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
11266: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
11345: /* removed nvl to default return to location id */
11346: /* instead, if cursor is NOTFOUND, we use location id */
11347: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
11348: select hsck.segment18
11349: from HR_SOFT_CODING_KEYFLEX hsck,
11350: PER_ASSIGNMENTS_F paf
11351: where paf.assignment_id = p_assignment
11352: and p_session_dt between paf.effective_start_date
11353: and paf.effective_end_date