APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on PER_ALL_PEOPLE_F

Line 247: from per_all_people_f ppf,

243:
244: /* Cursor to get the party id of the employee */
245: cursor emp_party_id_cur IS
246: select ppf.party_id
247: from per_all_people_f ppf,
248: jtf_rs_resource_extns res
249: where res.category = 'EMPLOYEE'
250: and res.source_id = ppf.person_id
251: and res.resource_id = p_resource_id

Line 410: from per_all_people_f ppf

406:
407: /* Cursor to get the party id of the employee */
408: cursor emp_party_id_cur IS
409: select party_id
410: from per_all_people_f ppf
411: where ppf.person_id = ll_source_id
412: order by ppf.effective_start_date desc;
413:
414: l_person_party_id number;

Line 474: from per_all_people_f ppf

470:
471: /* Cursor to get the party id of the employee */
472: cursor emp_party_id_cur IS
473: select party_id
474: from per_all_people_f ppf
475: where ppf.person_id = ll_source_id
476: order by ppf.effective_start_date desc;
477:
478: l_person_party_id number;