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 71: from pay_people_groups link_group

67: segment11, segment12, segment13, segment14, segment15,
68: segment16, segment17, segment18, segment19, segment20,
69: segment21, segment22, segment23, segment24, segment25,
70: segment26, segment27, segment28, segment29, segment30
71: from pay_people_groups link_group
72: where link_group.people_group_id = p_people_group_id;
73: --
74: type segment_table is table of varchar2(60)
75: index by binary_integer;

Line 233: pay_people_groups ASSIGNMENT_GROUP

229: select assignment.assignment_id,
230: assignment.effective_start_date,
231: assignment.effective_end_date
232: from per_all_assignments_f ASSIGNMENT,
233: pay_people_groups ASSIGNMENT_GROUP
234: where assignment.assignment_type not in (''A'',''O'')
235: and assignment.business_group_id + 0 = :p_business_group_id
236: and assignment.effective_start_date <= :p_effective_end_date
237: and assignment.effective_end_date >= :p_effective_start_date

Line 431: from pay_people_groups el_pg,

427: --
428: cursor csr_pg
429: is
430: select 1
431: from pay_people_groups el_pg,
432: pay_people_groups asg_pg
433: where asg_pg.people_group_id = p_asg_people_group_id
434: and el_pg.people_group_id = p_link_people_group_id
435: and el_pg.id_flex_num = asg_pg.id_flex_num

Line 432: pay_people_groups asg_pg

428: cursor csr_pg
429: is
430: select 1
431: from pay_people_groups el_pg,
432: pay_people_groups asg_pg
433: where asg_pg.people_group_id = p_asg_people_group_id
434: and el_pg.people_group_id = p_link_people_group_id
435: and el_pg.id_flex_num = asg_pg.id_flex_num
436: and (el_pg.segment1 is null or el_pg.segment1 = asg_pg.segment1)

Line 1050: pay_people_groups ppg

1046: asg.business_group_id,
1047: asg.people_group_id,
1048: ppg.id_flex_num
1049: from per_all_assignments_f asg,
1050: pay_people_groups ppg
1051: where asg.assignment_id = p_assignment_id
1052: and asg.assignment_type not in ('A','O')
1053: and asg.people_group_id is not null
1054: and ppg.people_group_id = asg.people_group_id

Line 1071: pay_people_groups el_pg,

1067: select el.element_link_id,
1068: min(el.effective_start_date) effective_start_date,
1069: max(el.effective_end_date) effective_end_date
1070: from pay_element_links_f el,
1071: pay_people_groups el_pg,
1072: pay_people_groups asg_pg
1073: where asg_pg.id_flex_num = p_id_flex_num
1074: and asg_pg.people_group_id = p_people_group_id
1075: and el_pg.id_flex_num = asg_pg.id_flex_num

Line 1072: pay_people_groups asg_pg

1068: min(el.effective_start_date) effective_start_date,
1069: max(el.effective_end_date) effective_end_date
1070: from pay_element_links_f el,
1071: pay_people_groups el_pg,
1072: pay_people_groups asg_pg
1073: where asg_pg.id_flex_num = p_id_flex_num
1074: and asg_pg.people_group_id = p_people_group_id
1075: and el_pg.id_flex_num = asg_pg.id_flex_num
1076: and el.business_group_id + 0 = p_business_group_id