APPS.BEN_DERIVE_FACTORS dependencies on PER_ALL_PEOPLE_F

Line 496: per_all_people_f per

492: -- per_assignments_f asg,
493: per_all_assignments_f asg,
494: per_pay_bases ppb,
495: pay_all_payrolls_f paf,
496: per_all_people_f per
497: where per.person_id = p_person_id
498:
499: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'
500: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).

Line 547: per_all_people_f per

543: per_all_assignments_f asg,
544: per_assignment_extra_info aei,
545: per_pay_bases ppb,
546: pay_all_payrolls_f paf,
547: per_all_people_f per
548: where per.person_id = p_person_id
549: and asg.assignment_type = 'B'
550: and asg.person_id = per.person_id
551: -- 4455689

Line 566: per_all_people_f per

562: and l_date between per.effective_start_date and per.effective_end_date
563: and asg.assignment_id = aei.assignment_id
564: and not exists (select 1
565: from per_all_assignments_f asg,
566: per_all_people_f per
567: where per.person_id = p_person_id
568: and asg.assignment_type = 'E'
569: and asg.person_id = per.person_id
570: and l_date between asg.effective_start_date and asg.effective_end_date

Line 677: FROM per_all_people_f per

673: -- 3752197
674: Cursor c_ass_after_detdt is
675: --Start Bug 14456969: Modified the cursor conditions to identify Ex-Emp Rehire
676: SELECT min (ass.effective_start_date)
677: FROM per_all_people_f per
678: , per_all_assignments_f ass
679: WHERE per.person_id = p_person_id
680: AND per.person_id = ass.person_id
681: AND per.current_employee_flag = 'Y'

Line 694: FROM per_all_people_f per

690: --Start Bug 14161081
691: --Start Bug 14456969: Modified the cursor conditions to identify Ex-Emp Rehire
692: Cursor c_exists_ass_as_of_detdt is
693: SELECT 1
694: FROM per_all_people_f per
695: , per_all_assignments_f ass
696: WHERE per.person_id = p_person_id
697: AND per.person_id = ass.person_id
698: AND per.current_employee_flag = 'Y'

Line 715: FROM per_all_people_f per

711: --Start Bug 14456969
712: --Added an Cursor to fetch the latest termination date
713: Cursor c_per_lst_term_dt is
714: SELECT max(per.effective_start_date)
715: FROM per_all_people_f per
716: WHERE per.person_id = p_person_id
717: AND per.current_employee_flag IS NULL
718: AND trunc (per.effective_start_date) >= trunc (l_date);
719:

Line 725: FROM per_all_people_f per

721:
722: --Cursor to fetch the latest hire date
723: Cursor c_per_lst_hire_dt is
724: SELECT min(per.effective_start_date)
725: FROM per_all_people_f per
726: WHERE per.person_id = p_person_id
727: AND per.current_employee_flag = 'Y'
728: AND per.effective_start_date > l_per_lst_term_dt;
729:

Line 1792: from per_all_people_f per

1788: -- FONM
1789: --
1790: cursor c_per is
1791: select per.date_of_birth
1792: from per_all_people_f per
1793: where per.person_id = p_person_id
1794: and per.business_group_id = p_business_group_id
1795: and l_effective_date
1796: between per.effective_start_date

Line 1803: per_all_people_f per

1799:
1800: cursor c_per_spouse(l_person_id number) is
1801: select per.date_of_birth
1802: from per_contact_relationships ctr,
1803: per_all_people_f per
1804: where ctr.person_id = l_person_id
1805: and per.person_id = ctr.contact_person_id
1806: and per.business_group_id = p_business_group_id
1807: and ctr.personal_flag = 'Y'

Line 1820: per_all_people_f per

1816: --
1817: cursor c_per_depen_first(l_person_id number) is
1818: select per.date_of_birth
1819: from per_contact_relationships ctr,
1820: per_all_people_f per
1821: where ctr.person_id = l_person_id
1822: and per.person_id = ctr.contact_person_id
1823: and per.business_group_id = p_business_group_id
1824: and ctr.personal_flag = 'Y'

Line 1838: per_all_people_f per

1834: --
1835: cursor c_per_child_first(l_person_id number) is
1836: select per.date_of_birth
1837: from per_contact_relationships ctr,
1838: per_all_people_f per
1839: where ctr.person_id = l_person_id
1840: and per.person_id = ctr.contact_person_id
1841: and per.business_group_id = p_business_group_id
1842: and ctr.personal_flag = 'Y'

Line 1856: per_all_people_f per

1852: --
1853: cursor c_per_depen_oldest(l_person_id number) is
1854: select min(per.date_of_birth)
1855: from per_contact_relationships ctr,
1856: per_all_people_f per
1857: where ctr.person_id = l_person_id
1858: and per.person_id = ctr.contact_person_id
1859: and per.business_group_id = p_business_group_id
1860: and ctr.personal_flag = 'Y'

Line 1874: per_all_people_f per

1870: --
1871: cursor c_per_child_oldest(l_person_id number) is
1872: select min(per.date_of_birth)
1873: from per_contact_relationships ctr,
1874: per_all_people_f per
1875: where ctr.person_id = l_person_id
1876: and per.person_id = ctr.contact_person_id
1877: and per.business_group_id = p_business_group_id
1878: and ctr.personal_flag = 'Y'

Line 1892: per_all_people_f per

1888: --
1889: cursor c_per_depen_young(l_person_id number) is
1890: select max(per.date_of_birth)
1891: from per_contact_relationships ctr,
1892: per_all_people_f per
1893: where ctr.person_id = l_person_id
1894: and per.person_id = ctr.contact_person_id
1895: and per.business_group_id = p_business_group_id
1896: and ctr.personal_flag = 'Y'

Line 1910: per_all_people_f per

1906: --
1907: cursor c_per_child_young(l_person_id number) is
1908: select max(per.date_of_birth)
1909: from per_contact_relationships ctr,
1910: per_all_people_f per
1911: where ctr.person_id = l_person_id
1912: and per.business_group_id = p_business_group_id
1913: and per.person_id = ctr.contact_person_id
1914: and ctr.personal_flag = 'Y'

Line 2387: from per_all_people_f ppf,

2383: cursor c_person is
2384: select pps.date_start,
2385: pps.adjusted_svc_date,
2386: ppf.original_date_of_hire
2387: from per_all_people_f ppf,
2388: per_periods_of_service pps
2389: where pps.person_id(+) = ppf.person_id
2390: and ppf.person_id = p_person_id
2391: and ppf.business_group_id = p_business_group_id