APPS.PAY_KW_PAYROLL_REGISTER dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 204: from per_org_structure_elements pose

200: AND ptp.end_date = l_effective_date
201: AND ppf.payroll_id = ptp.payroll_id
202: AND l_effective_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
203: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
204: from per_org_structure_elements pose
205: connect by pose.organization_id_parent =
206: prior pose.organization_id_child
207: and pose.org_structure_version_id =
208: to_char (l_org_structure_version_id)

Line 281: from per_org_structure_elements pose

277: AND ptp.end_date = l_effective_date
278: AND ppf.payroll_id = ptp.payroll_id
279: AND l_effective_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
280: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
281: from per_org_structure_elements pose
282: connect by pose.organization_id_parent =
283: prior pose.organization_id_child
284: and pose.org_structure_version_id =
285: to_char (l_org_structure_version_id)

Line 317: from per_org_structure_elements pose

313: AND pai_emp.action_information2 = l_organization_id;
314: /* Cursor to tune the condition one sql performance */
315: Cursor csr_cond_1_tune (l_org_structure_version_id number,l_organization_id number, l_parent_id number) is
316: select to_char(pose.organization_id_child)
317: from per_org_structure_elements pose
318: connect by pose.organization_id_parent =
319: prior pose.organization_id_child
320: and pose.org_structure_version_id = to_char (l_org_structure_version_id)
321: start with pose.organization_id_parent = to_char(nvl(l_organization_id,l_parent_id))

Line 543: from per_org_structure_elements pose

539: AND ptp.time_period_id = pai_emp.action_information16
540: AND pai_emp.action_context_type = 'AAP'
541: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
542: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
543: from per_org_structure_elements pose
544: connect by pose.organization_id_parent =
545: prior pose.organization_id_child
546: and pose.org_structure_version_id =
547: to_char (l_org_structure_version_id)

Line 658: from per_org_structure_elements pose

654: AND ptp.time_period_id = pai_emp.action_information16
655: AND pai_emp.action_context_type = 'AAP'
656: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
657: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
658: from per_org_structure_elements pose
659: connect by pose.organization_id_parent =
660: prior pose.organization_id_child
661: and pose.org_structure_version_id =
662: to_char (l_org_structure_version_id)

Line 799: from per_org_structure_elements pose

795: if p_organization_id is null then
796: begin
797: select distinct pose.organization_id_parent
798: into l_parent_id
799: from per_org_structure_elements pose
800: where pose.org_structure_version_id = p_org_structure_version_id
801: and pose.organization_id_parent not in (select pose1.organization_id_child
802: from per_org_structure_elements pose1
803: where pose1.org_structure_version_id = p_org_structure_version_id);

Line 802: from per_org_structure_elements pose1

798: into l_parent_id
799: from per_org_structure_elements pose
800: where pose.org_structure_version_id = p_org_structure_version_id
801: and pose.organization_id_parent not in (select pose1.organization_id_child
802: from per_org_structure_elements pose1
803: where pose1.org_structure_version_id = p_org_structure_version_id);
804: exception
805: when others then
806: l_err := 1;