eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_OFFER_CUSTOM dependencies on PER_ASSIGN_PROPOSAL_ANSWERS

Line 28: From per_assign_proposal_answers papa

24: Begin
25: --
26: Select count(*)
27: Into l_count
28: From per_assign_proposal_answers papa
29: Where papa.proposal_question_name = p_proposal_question_name
30: and exists
31: (Select *
32: From wf_item_activity_statuses wf

Line 305: ,per_assign_proposal_answers papa

301: cursor csr_papa is
302: select distinct papa.person_id, pj.name
303: from per_jobs_tl pj
304: ,per_assignments pa
305: ,per_assign_proposal_answers papa
306: where pj.job_id = pa.job_id
307: and pj.language=userenv('LANG')
308: and pa.primary_flag = 'Y'
309: and pa.person_id = papa.person_id

Line 461: -- from per_assign_proposal_answers papa

457: --So, we should get the hiring manager from per_all_assignments_f
458:
459: --cursor csr_papa is
460: -- select distinct papa.person_id
461: -- from per_assign_proposal_answers papa
462: -- where papa.assignment_id = p_candidate_assignment_id;
463:
464: cursor csr_supervisor is
465: select asg.supervisor_id