APPS.PAY_JP_IWHT_ARCH_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 60: gn_business_group_id hr_all_organization_units.organization_id%type;

56: --
57: -- Global to store package name for tracing.
58: -- Declaration of global variables
59: gn_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
60: gn_business_group_id hr_all_organization_units.organization_id%type;
61: gn_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
62: gb_debug BOOLEAN;
63: gd_end_date DATE;
64: gd_start_date DATE;

Line 618: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE

614: CURSOR lcu_emp_assignment_det_r(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
615: ,p_business_group_id per_assignments_f.business_group_id%TYPE
616: ,p_effective_date DATE
617: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE
618: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE
619: ,p_termination_date_from DATE
620: ,p_termination_date_to DATE
621: )
622: IS

Line 676: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE

672: ,p_end_person_id per_all_people_f.person_id%TYPE
673: ,p_business_group_id per_assignments_f.business_group_id%TYPE
674: ,p_effective_date DATE
675: ,p_payroll_id pay_payrolls_f.payroll_id%TYPE
676: ,p_with_hold_id hr_all_organization_units.organization_id%TYPE
677: ,p_termination_date_from DATE
678: ,p_termination_date_to DATE
679: )
680: IS

Line 1011: FROM hr_all_organization_units HOU,

1007: ,HOI.org_information6
1008: ,HOI.org_information7
1009: ,HOI.org_information8
1010: ,HOI.org_information12
1011: FROM hr_all_organization_units HOU,
1012: hr_organization_information HOI
1013: WHERE HOU.organization_id = p_itax_organization_id
1014: AND HOI.organization_id(+) = hou.organization_id
1015: AND HOI.org_information_context(+) = 'JP_TAX_SWOT_INFO';