DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PER_ALL_PEOPLE_F

Line 1879: ,per_all_people_f ppf

1875: SELECT NVL(paf.work_at_home, 'N')
1876: ,ppf.person_id
1877: ,ppf.business_group_id
1878: FROM per_assignments_f paf
1879: ,per_all_people_f ppf
1880: WHERE paf.assignment_id = cp_assignment_id
1881: AND paf.person_id = ppf.person_id;
1882:
1883: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER

Line 4348: ,per_all_people_f ppf

4344: SELECT NVL(paf.work_at_home, 'N')
4345: ,ppf.person_id
4346: ,ppf.business_group_id
4347: FROM per_assignments_f paf
4348: ,per_all_people_f ppf
4349: WHERE paf.assignment_id = cp_assignment_id
4350: AND paf.person_id = ppf.person_id;
4351:
4352: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER

Line 4850: ,per_all_people_f ppf

4846: SELECT NVL(paf.work_at_home, 'N')
4847: ,ppf.person_id
4848: ,ppf.business_group_id
4849: FROM per_assignments_f paf
4850: ,per_all_people_f ppf
4851: WHERE paf.assignment_id = cp_assignment_id
4852: AND paf.person_id = ppf.person_id;
4853:
4854: CURSOR c_cur_home_state_jd(cp_person_id IN NUMBER