APPS.PAY_AE_PAYROLL_REGISTER dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 202: from per_org_structure_elements pose

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

Line 279: from per_org_structure_elements pose

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

Line 315: from per_org_structure_elements pose

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

Line 513: from per_org_structure_elements pose

509: AND ptp.time_period_id = pai_emp.action_information16
510: AND pai_emp.action_context_type = 'AAP'
511: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
512: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
513: from per_org_structure_elements pose
514: connect by pose.organization_id_parent =
515: prior pose.organization_id_child
516: and pose.org_structure_version_id =
517: to_char (l_org_structure_version_id)

Line 552: from per_org_structure_elements pose

548: AND ptp.time_period_id = pai_emp.action_information16
549: AND pai_emp.action_context_type = 'AAP'
550: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
551: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
552: from per_org_structure_elements pose
553: connect by pose.organization_id_parent =
554: prior pose.organization_id_child
555: and pose.org_structure_version_id =
556: to_char (l_org_structure_version_id)

Line 710: from per_org_structure_elements pose

706: AND ptp.time_period_id = pai_emp.action_information16
707: AND pai_emp.action_context_type = 'AAP'
708: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
709: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
710: from per_org_structure_elements pose
711: connect by pose.organization_id_parent =
712: prior pose.organization_id_child
713: and pose.org_structure_version_id =
714: to_char (l_org_structure_version_id)

Line 749: from per_org_structure_elements pose

745: AND ptp.time_period_id = pai_emp.action_information16
746: AND pai_emp.action_context_type = 'AAP'
747: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
748: AND pai_emp.action_information2 in (select to_char(pose.organization_id_child)
749: from per_org_structure_elements pose
750: connect by pose.organization_id_parent =
751: prior pose.organization_id_child
752: and pose.org_structure_version_id =
753: to_char (l_org_structure_version_id)

Line 933: from per_org_structure_elements pose

929: if p_organization_id is null then
930: begin
931: select distinct pose.organization_id_parent
932: into l_parent_id
933: from per_org_structure_elements pose
934: where pose.org_structure_version_id = p_org_structure_version_id
935: and pose.organization_id_parent not in (select pose1.organization_id_child
936: from per_org_structure_elements pose1
937: where pose1.org_structure_version_id = p_org_structure_version_id);

Line 936: from per_org_structure_elements pose1

932: into l_parent_id
933: from per_org_structure_elements pose
934: where pose.org_structure_version_id = p_org_structure_version_id
935: and pose.organization_id_parent not in (select pose1.organization_id_child
936: from per_org_structure_elements pose1
937: where pose1.org_structure_version_id = p_org_structure_version_id);
938: exception
939: when others then
940: l_err := 1;