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.PER_QH_FIND_QUERY dependencies on PER_RECRUITMENT_ACTIVITIES

Line 71: ,recruitment_activity per_recruitment_activities.name%type default null

67: ,supervisor per_all_people_f.full_name%type default null
68: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
69: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
70: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
71: ,recruitment_activity per_recruitment_activities.name%type default null
72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
73: ,organization hr_all_organization_units.name%type default null
74: ,organization_id per_all_assignments_f.organization_id%type default null
75: ,people_group pay_people_groups.group_name%type default null

Line 283: from per_recruitment_activities

279: --
280: cursor csr_rec_activity
281: (p_recruitment_activity_id number) is
282: select name
283: from per_recruitment_activities
284: where recruitment_activity_id=p_recruitment_activity_id;
285: --
286: cursor csr_organization
287: (p_organization_id number) is

Line 1156: l_from_clause:=l_from_clause||',per_recruitment_activities ract';

1152: if recruitment_activity_id is not null then
1153: l_where_clause:=l_where_clause||' and per_asg.recruitment_activity_id='||recruitment_activity_id;
1154: l_asg:=TRUE;
1155: elsif recruitment_activity is not null then
1156: l_from_clause:=l_from_clause||',per_recruitment_activities ract';
1157: l_where_clause:=l_where_clause||' and per_asg.recruitment_activity_id = ract.recruitment_activity_id'
1158: ||' and upper(ract.name) like ('''||upper(replace(recruitment_activity,g_quote,g_quote||g_quote))||''')';
1159: l_asg:=TRUE;
1160: end if;

Line 2513: ,recruitment_activity in per_recruitment_activities.name%type default null

2509: ,supervisor in per_all_people_f.full_name%type default null
2510: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2511: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2512: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2513: ,recruitment_activity in per_recruitment_activities.name%type default null
2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2515: ,organization in hr_all_organization_units.name%type default null
2516: ,organization_id in per_all_assignments_f.organization_id%type default null
2517: ,people_group in pay_people_groups.group_name%type default null