APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_ASSIGNMENTS_F

Line 341: from per_assignments_f

337: --
338: -- Bug 4915940
339: cursor csr_person_id(p_eff_date in date) is
340: select person_id
341: from per_assignments_f
342: where assignment_id = p_assignment_id
343: and p_eff_date between effective_start_date and effective_end_date ;
344: --
345: cursor csr_get_session_id is

Line 603: from per_assignments_f paf

599:
600: -- cursor to get organization id of the Employee.
601: cursor csr_emp_org_id is
602: select organization_id
603: from per_assignments_f paf
604: where assignment_id = p_assignment_id
605: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
606:
607: --

Line 869: from per_assignments_f

865: --
866: CURSOR csr_get_person_id(p_assignment_id NUMBER)
867: is
868: select person_id
869: from per_assignments_f
870: where assignment_id = p_assignment_id;
871: --
872: l_formula_id NUMBER;
873: l_inputs ff_exec.inputs_t;

Line 1348: per_assignments_f paf

1344:
1345: cursor csr_house_holder(p_assgn_id in number, p_eff_date in date) is
1346: select nvl(pei.PEI_INFORMATION3,'N')
1347: from PER_PEOPLE_EXTRA_INFO pei,
1348: per_assignments_f paf
1349: where paf.assignment_id = p_assgn_id
1350: and p_eff_date between paf.effective_start_date and paf.effective_end_DATE
1351: and pei.person_id = paf.person_id
1352: and information_type = 'PER_KR_RELATED_YEA_INFORMATION';