APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_ASSIGNMENTS_F

Line 565: from per_assignments_f

561: --
562: -- Bug 4915940
563: cursor csr_person_id(p_eff_date in date) is
564: select person_id
565: from per_assignments_f
566: where assignment_id = p_assignment_id
567: and p_eff_date between effective_start_date and effective_end_date ;
568: --
569: cursor csr_get_session_id is

Line 1265: from per_assignments_f paf

1261:
1262: -- cursor to get organization id of the Employee.
1263: cursor csr_emp_org_id is
1264: select organization_id
1265: from per_assignments_f paf
1266: where assignment_id = p_assignment_id
1267: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
1268:
1269: --

Line 1531: from per_assignments_f

1527: --
1528: CURSOR csr_get_person_id(p_assignment_id NUMBER)
1529: is
1530: select person_id
1531: from per_assignments_f
1532: where assignment_id = p_assignment_id;
1533: --
1534: l_formula_id NUMBER;
1535: l_inputs ff_exec.inputs_t;

Line 2070: per_assignments_f paf

2066:
2067: cursor csr_house_holder(p_assgn_id in number, p_eff_date in date) is
2068: select nvl(pei.PEI_INFORMATION3,'N')
2069: from PER_PEOPLE_EXTRA_INFO pei,
2070: per_assignments_f paf
2071: where paf.assignment_id = p_assgn_id
2072: and p_eff_date between paf.effective_start_date and paf.effective_end_DATE
2073: and pei.person_id = paf.person_id
2074: and information_type = 'PER_KR_RELATED_YEA_INFORMATION';

Line 2081: from per_assignments_f asg,

2077: -- Bug 9246066: Updated to display terminated employee information in SSHR YEA
2078: --
2079: cursor csr_get_eff_date(p_assgn_id in number, p_eff_date in date) is
2080: select nvl(ppos.final_process_date,p_eff_date)
2081: from per_assignments_f asg,
2082: per_periods_of_service ppos
2083: where asg.assignment_id = p_assgn_id
2084: and ppos.period_of_service_id = asg.period_of_service_id
2085: and nvl(ppos.final_process_date,p_eff_date) between asg.effective_start_date and asg.effective_end_date;