[Home] [Help]
5563:
5564:
5565: cursor csr_get_asg_gre (p_assignment number)is
5566: select hsck.segment1
5567: from hr_soft_coding_keyflex hsck,
5568: per_assignments_f paf
5569: where paf.assignment_id = p_assignment
5570: and p_effective_start_date between paf.effective_start_date
5571: and paf.effective_end_date
6215:
6216: cursor c_tax_unit_id(p_assignment_id in number,
6217: p_session_date in date) is
6218: select to_number(segment1) tax_unit_id
6219: from hr_soft_coding_keyflex a,
6220: per_assignments_f b
6221: where b.assignment_id = p_assignment_id
6222: and b.soft_coding_keyflex_id = a.soft_coding_keyflex_id
6223: and p_session_date between b.effective_start_date and b.effective_end_date ;
7760: and rownum < 2;
7761:
7762: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
7763: select nvl(hsck.segment18, paf.location_id)
7764: from HR_SOFT_CODING_KEYFLEX hsck,
7765: PER_ASSIGNMENTS_F paf
7766: where paf.assignment_id = p_assignment
7767: and p_session_dt between paf.effective_start_date
7768: and paf.effective_end_date
8079: and rownum < 2;
8080:
8081: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
8082: select nvl(hsck.segment18, paf.location_id)
8083: from HR_SOFT_CODING_KEYFLEX hsck,
8084: PER_ASSIGNMENTS_F paf
8085: where paf.assignment_id = p_assignment
8086: and p_session_dt between paf.effective_start_date
8087: and paf.effective_end_date
9107: and rownum < 2;
9108:
9109: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
9110: select nvl(hsck.segment18, paf.location_id)
9111: from HR_SOFT_CODING_KEYFLEX hsck,
9112: PER_ASSIGNMENTS_F paf
9113: where paf.assignment_id = p_assignment
9114: and p_session_dt between paf.effective_start_date
9115: and paf.effective_end_date
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'
11251: and paf.soft_coding_keyflex_id is not null
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'
11274: and paf.soft_coding_keyflex_id is not null
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'
11299: and paf.soft_coding_keyflex_id is not null
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
11321: and paf.effective_end_date
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
11342: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
11421: /* removed nvl to default return to location id */
11422: /* instead, if cursor is NOTFOUND, we use location id */
11423: cursor csr_get_ovrd_loc(p_assignment number, p_session_dt date) is
11424: select hsck.segment18
11425: from HR_SOFT_CODING_KEYFLEX hsck,
11426: PER_ASSIGNMENTS_F paf
11427: where paf.assignment_id = p_assignment
11428: and p_session_dt between paf.effective_start_date
11429: and paf.effective_end_date