APPS.IRC_WEB dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 18: ,per_recruitment_activity_for prf

14: --
15: cursor csr_posting(p_vac_id number) is
16: select to_char(pra.posting_content_id)
17: from per_recruitment_activities pra
18: ,per_recruitment_activity_for prf
19: where prf.vacancy_id=p_vac_id
20: and pra.recruitment_activity_id=prf.recruitment_activity_id
21: and pra.posting_content_id is not null
22: order by pra.date_start;