APPS.PAY_AU_PAYTAX_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 45: g_business_group_id hr_all_organization_units.organization_id%type;

41: g_package varchar2(26);
42:
43:
44: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
45: g_business_group_id hr_all_organization_units.organization_id%type;
46: g_prev_assignment_id number;
47: g_le_taxable_income number;
48: g_count number;
49: g_prev_tax_state varchar2(3);

Line 408: cursor csr_get_ass_le_act_id (c_business_group_id hr_all_organization_units.organization_id%TYPE,

404: AND pbd.balance_dimension_id = pdb.balance_dimension_id
405: AND pbt.legislation_code = 'AU';
406:
407: /* 4713372 */
408: cursor csr_get_ass_le_act_id (c_business_group_id hr_all_organization_units.organization_id%TYPE,
409: c_registered_employer hr_all_organization_units.organization_id%TYPE,
410: c_start_date date,
411: c_end_date date)
412: is

Line 409: c_registered_employer hr_all_organization_units.organization_id%TYPE,

405: AND pbt.legislation_code = 'AU';
406:
407: /* 4713372 */
408: cursor csr_get_ass_le_act_id (c_business_group_id hr_all_organization_units.organization_id%TYPE,
409: c_registered_employer hr_all_organization_units.organization_id%TYPE,
410: c_start_date date,
411: c_end_date date)
412: is
413: select distinct per_information2, paa.tax_unit_id,

Line 573: ,p_business_group_id hr_all_organization_units.organization_id%type

569: (p_payroll_action_id pay_payroll_actions.payroll_action_id%type
570: ,p_start_person per_all_people_f.person_id%type
571: ,p_end_person per_all_people_f.person_id%type
572: ,p_report_type varchar2
573: ,p_business_group_id hr_all_organization_units.organization_id%type
574: ,p_legal_employer hr_all_organization_units.organization_id%type
575: ,p_archive_start_date date
576: ,p_archive_end_date date
577: ,p_tax_state varchar2

Line 574: ,p_legal_employer hr_all_organization_units.organization_id%type

570: ,p_start_person per_all_people_f.person_id%type
571: ,p_end_person per_all_people_f.person_id%type
572: ,p_report_type varchar2
573: ,p_business_group_id hr_all_organization_units.organization_id%type
574: ,p_legal_employer hr_all_organization_units.organization_id%type
575: ,p_archive_start_date date
576: ,p_archive_end_date date
577: ,p_tax_state varchar2
578: ) is

Line 786: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,

782: and pap1.effective_end_date >= c_start_date
783: and pap1.effective_start_date <= c_end_date
784: );
785:
786: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,
787: c_assignment_id number,c_end_date date, c_start_date date,
788: c_assignment_action_id number,
789: c_payroll_action_id number)
790: is /* 5893671 - commented out full name*/