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 PAY_PEOPLE_GROUPS

Line 75: ,people_group pay_people_groups.group_name%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
76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null

Line 294: select * from pay_people_groups

290: where organization_id=p_organization_id;
291: --
292: cursor csr_pgp_rec
293: (p_people_group_id number) is
294: select * from pay_people_groups
295: where people_group_id=p_people_group_id;
296: --
297: cursor csr_scl_rec
298: (p_soft_coding_keyflex_id number) is

Line 366: pgp_rec pay_people_groups%rowtype;

362: and application_id=800
363: and id_flex_num=p_id_flex_num;
364: --
365: asg_rec per_all_assignments_f%rowtype;
366: pgp_rec pay_people_groups%rowtype;
367: scl_rec hr_soft_coding_keyflex%rowtype;
368: --
369: cursor csr_vendor(p_vendor_id in number) is
370: select vendor_name

Line 665: ,'pay_people_groups pgp_a','pgp_a.people_group_id','pgp_a.group_name');

661: ,'ben_pgm_f pgm','pgm.pgm_id','pgm.name');
662: l_asg:=TRUE;
663: elsif p_field_name='PEOPLE_GROUP' then
664: l_a_where_clause:=build_varchar2_where('per_asg.people_group_id',p_condition,p_value
665: ,'pay_people_groups pgp_a','pgp_a.people_group_id','pgp_a.group_name');
666: l_asg:=TRUE;
667: elsif p_field_name='SUPERVISOR' then
668: l_a_where_clause:=build_varchar2_where('per_asg.supervisor_id',p_condition,p_value
669: ,'per_all_people_f sup_a','sup_a.person_id','sup_a.full_name');

Line 1181: l_from_clause:=l_from_clause||',pay_people_groups ppg';

1177: if people_group_id is not null then
1178: l_where_clause:=l_where_clause||' and per_asg.people_group_id='||people_group_id;
1179: l_asg:=TRUE;
1180: elsif people_group is not null then
1181: l_from_clause:=l_from_clause||',pay_people_groups ppg';
1182: l_where_clause:=l_where_clause||' and per_asg.people_group_id=ppg.people_group_id'
1183: ||' and upper(ppg.group_name) like ('''||upper(replace(people_group,g_quote,g_quote||g_quote))||''')';
1184: l_asg:=TRUE;
1185: end if;

Line 2517: ,people_group in pay_people_groups.group_name%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
2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2519: ,vacancy in per_vacancies.name%type default null
2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2521: ,requisition in per_requisitions.name%type default null