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.PAY_ASG_LINK_USAGES_PKG dependencies on PAY_PEOPLE_GROUPS

Line 81: pay_people_groups ppg,

77: least(asg.effective_end_date, el.effective_end_date) effective_end_date,
78: asg.business_group_id,
79: el.element_link_id
80: from per_all_assignments_f asg,
81: pay_people_groups ppg,
82: pay_element_links_f el,
83: pay_people_groups el_pg
84: where el_pg.id_flex_num = ppg.id_flex_num
85: and el.element_link_id = p_element_link_id

Line 83: pay_people_groups el_pg

79: el.element_link_id
80: from per_all_assignments_f asg,
81: pay_people_groups ppg,
82: pay_element_links_f el,
83: pay_people_groups el_pg
84: where el_pg.id_flex_num = ppg.id_flex_num
85: and el.element_link_id = p_element_link_id
86: and el.business_group_id + 0 = asg.business_group_id
87: and el.effective_start_date <= asg.effective_end_date

Line 139: from pay_people_groups link_group

135: segment11, segment12, segment13, segment14, segment15,
136: segment16, segment17, segment18, segment19, segment20,
137: segment21, segment22, segment23, segment24, segment25,
138: segment26, segment27, segment28, segment29, segment30
139: from pay_people_groups link_group
140: where link_group.people_group_id = p_people_group_id;
141: --
142: type segment_table is table of varchar2(60)
143: index by binary_integer;

Line 387: pay_people_groups ASSIGNMENT_GROUP

383: select assignment.assignment_id,
384: assignment.effective_start_date,
385: assignment.effective_end_date
386: from per_all_assignments_f ASSIGNMENT,
387: pay_people_groups ASSIGNMENT_GROUP
388: where assignment.assignment_type not in (''A'',''O'')
389: and assignment.business_group_id + 0 = :p_business_group_id
390: and assignment.effective_start_date <= :p_effective_end_date
391: and assignment.effective_end_date >= :p_effective_start_date

Line 610: from pay_people_groups el_pg,

606: --
607: cursor csr_pg
608: is
609: select 1
610: from pay_people_groups el_pg,
611: pay_people_groups asg_pg
612: where asg_pg.people_group_id = p_asg_people_group_id
613: and el_pg.people_group_id = p_link_people_group_id
614: and el_pg.id_flex_num = asg_pg.id_flex_num

Line 611: pay_people_groups asg_pg

607: cursor csr_pg
608: is
609: select 1
610: from pay_people_groups el_pg,
611: pay_people_groups asg_pg
612: where asg_pg.people_group_id = p_asg_people_group_id
613: and el_pg.people_group_id = p_link_people_group_id
614: and el_pg.id_flex_num = asg_pg.id_flex_num
615: and (el_pg.segment1 is null or el_pg.segment1 = asg_pg.segment1)

Line 1238: pay_people_groups ppg,

1234: least(asg.effective_end_date, el.effective_end_date) effective_end_date,
1235: asg.business_group_id,
1236: el.element_link_id
1237: from per_all_assignments_f asg,
1238: pay_people_groups ppg,
1239: pay_element_links_f el,
1240: pay_people_groups el_pg
1241: where el_pg.id_flex_num = ppg.id_flex_num
1242: and el.business_group_id + 0 = asg.business_group_id

Line 1240: pay_people_groups el_pg

1236: el.element_link_id
1237: from per_all_assignments_f asg,
1238: pay_people_groups ppg,
1239: pay_element_links_f el,
1240: pay_people_groups el_pg
1241: where el_pg.id_flex_num = ppg.id_flex_num
1242: and el.business_group_id + 0 = asg.business_group_id
1243: and el.effective_start_date <= asg.effective_end_date
1244: and el.effective_end_date >= asg.effective_start_date