[Home] [Help]
257: CURSOR get_salary is
258: select ppp.proposed_salary,
259: ppb.pay_basis
260: from per_pay_proposals ppp,
261: per_assignments_f paf,
262: per_pay_bases ppb
263: where paf.assignment_id = p_assignment_id and
264: ppp.assignment_id = paf.assignment_id and
265: paf.pay_basis_id = ppb.pay_basis_id and
273: CURSOR get_salary IS
274: SELECT ppp.proposed_salary,
275: ppb.pay_basis
276: FROM per_pay_proposals ppp,
277: per_assignments_f paf,
278: per_pay_bases ppb
279: WHERE paf.assignment_id = p_assignment_id
280: AND ppp.assignment_id = paf.assignment_id
281: AND paf.pay_basis_id = ppb.pay_basis_id
447: AND NVL(business_group_id, l_business_group_id) = l_business_group_id;
448:
449: CURSOR business_group_id_cur IS
450: SELECT business_group_id
451: FROM per_assignments_f
452: WHERE assignment_id = p_assignment_id
453: AND effective_start_date <= high_date
454: AND effective_end_date >= low_date;
455:
1331: p_return_status OUT NOCOPY VARCHAR2)
1332: IS
1333: CURSOR percent_effort_cur IS
1334: SELECT NVL(SUM(schedule_percent), 0)
1335: FROM per_assignments_f paf,
1336: psp_schedule_hierarchy psh,
1337: psp_schedule_lines psl
1338: WHERE paf.person_id = p_person_id
1339: AND TRUNC(p_effective_date) BETWEEN paf.effective_start_date AND paf.effective_end_date
2821:
2822:
2823: cursor eff_dates_csr is
2824: select max(paf.effective_end_date)
2825: from per_assignments_f paf
2826: where paf.assignment_id = p_assignment_id;
2827:
2828:
2829: l_date date ;
2831:
2832: cursor fetch_asg_status_csr(P_ASSIGNMENT_ID IN NUMBER,P_EFFECTIVE_DATE IN DATE )is
2833: select past.USER_STATUS
2834: from per_assignment_status_types past ,
2835: per_assignments_f paf
2836: where paf.assignment_id = p_assignment_id
2837: and past.ASSIGNMENT_STATUS_TYPE_ID = paf.ASSIGNMENT_STATUS_TYPE_ID
2838: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
2839: