DBA Data[Home] [Help]

APPS.PER_PMP_BUS dependencies on PER_ALL_PEOPLE_F

Line 482: from per_all_people_f ppf

478: -- Declare the cursor
479:
480: cursor csr_admin_person_id is
481: select 'Y'
482: from per_all_people_f ppf
483: where ppf.person_id = p_administrator_person_id
484: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
485:
486:

Line 970: -- Checks that the supervisor id is valid person id PER_ALL_PEOPLE_F.

966: -- ----------------------------------------------------------------------------
967: -- {Start Of Comments}
968: --
969: -- Description:
970: -- Checks that the supervisor id is valid person id PER_ALL_PEOPLE_F.
971: --
972: -- Prerequisites:
973: -- None.
974: --

Line 1001: from per_all_people_f ppf

997: -- Declare the cursor
998:
999: cursor csr_supervisor_id is
1000: select 'Y'
1001: from per_all_people_f ppf
1002: where ppf.person_id = p_supervisor_id
1003: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
1004:
1005: -- Declare local variables