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_AE_PAYROLL_REGISTER dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 227: from per_org_structure_elements pose

223: AND ptp.end_date = l_effective_date
224: AND ppf.payroll_id = ptp.payroll_id
225: AND l_effective_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
226: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
227: from per_org_structure_elements pose
228: connect by pose.organization_id_parent =
229: prior pose.organization_id_child
230: and pose.org_structure_version_id =
231: to_char (l_org_structure_version_id)

Line 259: from per_org_structure_elements pose

255: AND ptp.end_date = l_effective_date
256: AND ppf.payroll_id = ptp.payroll_id
257: AND l_effective_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
258: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
259: from per_org_structure_elements pose
260: connect by pose.organization_id_parent =
261: prior pose.organization_id_child
262: and pose.org_structure_version_id =
263: to_char (l_org_structure_version_id)

Line 369: from per_org_structure_elements pose

365: AND ptp.end_date = l_effective_date
366: AND ppf.payroll_id = ptp.payroll_id
367: AND l_effective_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
368: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
369: from per_org_structure_elements pose
370: connect by pose.organization_id_parent =
371: prior pose.organization_id_child
372: and pose.org_structure_version_id =
373: to_char (l_org_structure_version_id)

Line 400: from per_org_structure_elements pose

396: AND ptp.end_date = l_effective_date
397: AND ppf.payroll_id = ptp.payroll_id
398: AND l_effective_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
399: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
400: from per_org_structure_elements pose
401: connect by pose.organization_id_parent =
402: prior pose.organization_id_child
403: and pose.org_structure_version_id =
404: to_char (l_org_structure_version_id)

Line 436: from per_org_structure_elements pose

432: AND pai_emp.action_information2 = l_organization_id;
433: /* Cursor to tune the condition one sql performance */
434: Cursor csr_cond_1_tune (l_org_structure_version_id number,l_organization_id number, l_parent_id number) is
435: select to_char(pose.organization_id_child)
436: from per_org_structure_elements pose
437: connect by pose.organization_id_parent =
438: prior pose.organization_id_child
439: and pose.org_structure_version_id = to_char (l_org_structure_version_id)
440: start with pose.organization_id_parent = to_char(nvl(l_organization_id,l_parent_id))

Line 678: from per_org_structure_elements pose

674: AND ptp.time_period_id = pai_emp.action_information16
675: AND pai_emp.action_context_type = 'AAP'
676: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
677: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
678: from per_org_structure_elements pose
679: connect by pose.organization_id_parent =
680: prior pose.organization_id_child
681: and pose.org_structure_version_id =
682: to_char (l_org_structure_version_id)

Line 717: from per_org_structure_elements pose

713: AND ptp.time_period_id = pai_emp.action_information16
714: AND pai_emp.action_context_type = 'AAP'
715: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
716: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
717: from per_org_structure_elements pose
718: connect by pose.organization_id_parent =
719: prior pose.organization_id_child
720: and pose.org_structure_version_id =
721: to_char (l_org_structure_version_id)

Line 875: from per_org_structure_elements pose

871: AND ptp.time_period_id = pai_emp.action_information16
872: AND pai_emp.action_context_type = 'AAP'
873: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
874: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
875: from per_org_structure_elements pose
876: connect by pose.organization_id_parent =
877: prior pose.organization_id_child
878: and pose.org_structure_version_id =
879: to_char (l_org_structure_version_id)

Line 914: from per_org_structure_elements pose

910: AND ptp.time_period_id = pai_emp.action_information16
911: AND pai_emp.action_context_type = 'AAP'
912: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
913: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
914: from per_org_structure_elements pose
915: connect by pose.organization_id_parent =
916: prior pose.organization_id_child
917: and pose.org_structure_version_id =
918: to_char (l_org_structure_version_id)

Line 1098: from per_org_structure_elements pose

1094: if p_organization_id is null then
1095: begin
1096: select distinct pose.organization_id_parent
1097: into l_parent_id
1098: from per_org_structure_elements pose
1099: where pose.org_structure_version_id = p_org_structure_version_id
1100: and pose.organization_id_parent not in (select pose1.organization_id_child
1101: from per_org_structure_elements pose1
1102: where pose1.org_structure_version_id = p_org_structure_version_id);

Line 1101: from per_org_structure_elements pose1

1097: into l_parent_id
1098: from per_org_structure_elements pose
1099: where pose.org_structure_version_id = p_org_structure_version_id
1100: and pose.organization_id_parent not in (select pose1.organization_id_child
1101: from per_org_structure_elements pose1
1102: where pose1.org_structure_version_id = p_org_structure_version_id);
1103: exception
1104: when others then
1105: l_err := 1;