DBA Data[Home] [Help]

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 1140: l_from_clause:=l_from_clause||',per_recruitment_activities ract';

1136: if recruitment_activity_id is not null then
1137: l_where_clause:=l_where_clause||' and per_asg.recruitment_activity_id='||recruitment_activity_id;
1138: l_asg:=TRUE;
1139: elsif recruitment_activity is not null then
1140: l_from_clause:=l_from_clause||',per_recruitment_activities ract';
1141: l_where_clause:=l_where_clause||' and per_asg.recruitment_activity_id = ract.recruitment_activity_id'
1142: ||' and upper(ract.name) like ('''||upper(replace(recruitment_activity,g_quote,g_quote||g_quote))||''')';
1143: l_asg:=TRUE;
1144: end if;

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

2493: ,supervisor in per_all_people_f.full_name%type default null
2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2495: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2497: ,recruitment_activity in per_recruitment_activities.name%type default null
2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2499: ,organization in hr_all_organization_units.name%type default null
2500: ,organization_id in per_all_assignments_f.organization_id%type default null
2501: ,people_group in pay_people_groups.group_name%type default null