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.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_ALL_PEOPLE

Line 1701: per_all_people_f ppf,

1697: -- psb_positions,
1698: psb_positions_i pp,
1699: /* End bug #4128475 */
1700: per_all_assignments_f paf,
1701: per_all_people_f ppf,
1702: pay_all_payrolls_f ppay,
1703: per_pay_bases ppb
1704: WHERE fs.session_id = userenv('sessionid')
1705: AND fs.effective_date between paf.effective_start_date and paf.effective_end_date

Line 4585: 'PER_ALL_PEOPLE','P', 'HR_ALL_POSITIONS','PER_ALL_ASSIGNMENTS') link_type,link_type l_alias2,

4581: Select name, select_table,
4582: substr(select_table,1,instr(select_table,' ',1)) select_tab,
4583: select_column,select_key,
4584: link_key,decode(link_type,'A','PER_ALL_ASSIGNMENTS','E',
4585: 'PER_ALL_PEOPLE','P', 'HR_ALL_POSITIONS','PER_ALL_ASSIGNMENTS') link_type,link_type l_alias2,
4586: select_where
4587: From Psb_attribute_types
4588: Where attribute_type = d_attribute_type
4589: and attribute_type_id = d_attribute_type_id;

Line 4658: from per_all_people

4654: and data_extract_id = p_data_extract_id;
4655:
4656: Cursor C_Hiredate is
4657: Select start_date
4658: from per_all_people
4659: where person_id = l_person_id ;
4660:
4661: Cursor C_job_name is
4662: Select name

Line 5153: elsif (Attr_type_rec.link_type = 'PER_ALL_PEOPLE') then

5149:
5150: if (Attr_type_rec.link_type = 'PER_ALL_ASSIGNMENTS') then
5151: l_emp_col := 'assignment_id';
5152: --l_emp_val := Employee_rec.assignment_id;
5153: elsif (Attr_type_rec.link_type = 'PER_ALL_PEOPLE') then
5154: l_emp_col := 'person_id';
5155: --l_emp_val := Employee_rec.person_id;
5156: elsif (Attr_type_rec.link_type = 'HR_ALL_POSITIONS') then
5157: l_emp_col := 'position_id';

Line 5218: elsif (l_attr_link_type = 'PER_ALL_PEOPLE') then

5214: if (l_attr_link_type = 'PER_ALL_ASSIGNMENTS') then
5215: l_emp_val := Employee_rec.assignment_id;
5216: le_effective_start_date := lemp_effective_start_date;
5217: le_effective_end_date := lemp_effective_end_date;
5218: elsif (l_attr_link_type = 'PER_ALL_PEOPLE') then
5219: l_emp_val := Employee_rec.person_id;
5220: le_effective_start_date := lemp_effective_start_date;
5221: le_effective_end_date := lemp_effective_end_date;
5222: elsif (l_attr_link_type = 'HR_ALL_POSITIONS') then

Line 5304: elsif (Attr_type_rec.link_type = 'PER_ALL_PEOPLE') then

5300: Loop
5301: if (Attr_type_rec.link_type = 'PER_ALL_ASSIGNMENTS') then
5302: l_emp_col := 'assignment_id';
5303: --l_emp_val := Employee_rec.assignment_id;
5304: elsif (Attr_type_rec.link_type = 'PER_ALL_PEOPLE') then
5305: l_emp_col := 'person_id';
5306: --l_emp_val := Employee_rec.person_id;
5307: elsif (Attr_type_rec.link_type = 'HR_ALL_POSITIONS') then
5308: l_emp_col := 'position_id';

Line 5361: elsif (l_attr_link_type = 'PER_ALL_PEOPLE') then

5357: if (l_attr_link_type = 'PER_ALL_ASSIGNMENTS') then
5358: l_emp_val := Employee_rec.assignment_id;
5359: le_effective_start_date := lemp_effective_start_date;
5360: le_effective_end_date := lemp_effective_end_date;
5361: elsif (l_attr_link_type = 'PER_ALL_PEOPLE') then
5362: l_emp_val := Employee_rec.person_id;
5363: le_effective_start_date := lemp_effective_start_date;
5364: le_effective_end_date := lemp_effective_end_date;
5365: elsif (l_attr_link_type = 'HR_ALL_POSITIONS') then

Line 5460: elsif (Attr_type_rec.link_type = 'PER_ALL_PEOPLE') then

5456: Loop
5457: if (Attr_type_rec.link_type = 'PER_ALL_ASSIGNMENTS') then
5458: l_emp_col := 'assignment_id';
5459: --l_emp_val := Employee_rec.assignment_id;
5460: elsif (Attr_type_rec.link_type = 'PER_ALL_PEOPLE') then
5461: l_emp_col := 'person_id';
5462: --l_emp_val := Employee_rec.person_id;
5463: elsif (Attr_type_rec.link_type = 'HR_ALL_POSITIONS') then
5464: l_emp_col := 'position_id';

Line 5527: elsif (l_attr_link_type = 'PER_ALL_PEOPLE') then

5523: if (l_attr_link_type = 'PER_ALL_ASSIGNMENTS') then
5524: l_emp_val := Employee_rec.assignment_id;
5525: le_effective_start_date := lemp_effective_start_date;
5526: le_effective_end_date := lemp_effective_end_date;
5527: elsif (l_attr_link_type = 'PER_ALL_PEOPLE') then
5528: l_emp_val := Employee_rec.person_id;
5529: le_effective_start_date := lemp_effective_start_date;
5530: le_effective_end_date := lemp_effective_end_date;
5531: elsif (l_attr_link_type = 'HR_ALL_POSITIONS') then

Line 7165: 'PER_ALL_PEOPLE','P', 'HR_ALL_POSITIONS','PER_ALL_ASSIGNMENTS')

7161: Select name, select_table,attribute_type,
7162: substr(select_table,1,instr(select_table,' ',1)) select_tab,
7163: select_column,select_key,
7164: link_key,decode(link_type,'A','PER_ALL_ASSIGNMENTS','E',
7165: 'PER_ALL_PEOPLE','P', 'HR_ALL_POSITIONS','PER_ALL_ASSIGNMENTS')
7166: link_type,link_type l_alias2,
7167: select_where
7168: From Psb_attribute_types
7169: where attribute_type_id = p_attribute_type_id;

Line 7228: elsif (C_Attribute_Types_Rec.link_type = 'PER_ALL_PEOPLE') then

7224: end;
7225:
7226: if (C_Attribute_Types_Rec.link_type = 'PER_ALL_ASSIGNMENTS') then
7227: l_emp_col := 'assignment_id';
7228: elsif (C_Attribute_Types_Rec.link_type = 'PER_ALL_PEOPLE') then
7229: l_emp_col := 'person_id';
7230: elsif (C_Attribute_Types_Rec.link_type = 'HR_ALL_POSITIONS') then
7231: l_emp_col := 'position_id';
7232: end if;