DBA Data[Home] [Help]

APPS.PAY_AU_PAYTAX_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 46: g_business_group_id hr_all_organization_units.organization_id%type;

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

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

702: AND pbd.balance_dimension_id = pdb.balance_dimension_id
703: AND pbt.legislation_code = 'AU';
704:
705: /* 4713372 */
706: cursor csr_get_ass_le_act_id (c_business_group_id hr_all_organization_units.organization_id%TYPE,
707: c_registered_employer hr_all_organization_units.organization_id%TYPE,
708: c_start_date date,
709: c_end_date date)
710: is

Line 707: c_registered_employer hr_all_organization_units.organization_id%TYPE,

703: AND pbt.legislation_code = 'AU';
704:
705: /* 4713372 */
706: cursor csr_get_ass_le_act_id (c_business_group_id hr_all_organization_units.organization_id%TYPE,
707: c_registered_employer hr_all_organization_units.organization_id%TYPE,
708: c_start_date date,
709: c_end_date date)
710: is
711: select distinct per_information2, paa.tax_unit_id,

Line 874: ,p_business_group_id hr_all_organization_units.organization_id%type

870: (p_payroll_action_id pay_payroll_actions.payroll_action_id%type
871: ,p_start_person per_all_people_f.person_id%type
872: ,p_end_person per_all_people_f.person_id%type
873: ,p_report_type varchar2
874: ,p_business_group_id hr_all_organization_units.organization_id%type
875: ,p_legal_employer hr_all_organization_units.organization_id%type
876: ,p_archive_start_date date
877: ,p_archive_end_date date
878: ,p_tax_state varchar2

Line 875: ,p_legal_employer hr_all_organization_units.organization_id%type

871: ,p_start_person per_all_people_f.person_id%type
872: ,p_end_person per_all_people_f.person_id%type
873: ,p_report_type varchar2
874: ,p_business_group_id hr_all_organization_units.organization_id%type
875: ,p_legal_employer hr_all_organization_units.organization_id%type
876: ,p_archive_start_date date
877: ,p_archive_end_date date
878: ,p_tax_state varchar2
879: ) is

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

1083: and pap1.effective_end_date >= c_start_date
1084: and pap1.effective_start_date <= c_end_date
1085: );
1086:
1087: cursor c_employee_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,
1088: c_assignment_id number,c_end_date date, c_start_date date,
1089: c_assignment_action_id number,
1090: c_payroll_action_id number)
1091: is /* 5893671 - commented out full name*/