APPS.PAY_AU_PAYE_FF dependencies on HR_ALL_ORGANIZATION_UNITS

Line 669: p_business_group_id in hr_all_organization_units.organization_id%TYPE,

665: /* Bug#4467198 - Modified the function to take care of legal employer changes. Introduced following
666: parameters in the function p_use_tax_flag, p_payroll_id, p_assignment_action_id*/
667: FUNCTION calculate_asg_prev_value
668: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
669: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
670: p_date_earned in date,
671: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
672: p_assignment_action_id IN number,
673: p_payroll_id IN NUMBER,

Line 671: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,

667: FUNCTION calculate_asg_prev_value
668: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
669: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
670: p_date_earned in date,
671: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
672: p_assignment_action_id IN number,
673: p_payroll_id IN NUMBER,
674: p_period_start_date in date,
675: p_case out NOCOPY varchar2,

Line 726: c_business_group_id in hr_all_organization_units.organization_id%TYPE,

722: -- Assignment Action ID .
723: -----------------------------------------------------------------------
724: CURSOR c_get_prev_year_max_asg_act_id
725: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
726: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
727: c_fin_start_date in date,
728: c_fin_end_date in date)
729: IS
730: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id

Line 756: c_business_group_id in hr_all_organization_units.organization_id%TYPE,

752:
753:
754: CURSOR c_get_pre_le_max_asg_act_id
755: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
756: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
757: c_fin_start_date in date,
758: c_fin_end_date in date)
759: IS
760: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date

Line 799: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,

795: to count number of pay periods between greatest of (employee's hire date, financial year start date,
796: Legal Employer start date) and current period end date*/
797:
798: cursor c_get_periods
799: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
800: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
801: c_start_date in date,
802: c_end_date in date)
803: is

Line 823: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,

819:
820: /* bug 12753997 - New c_get_periods_1n3 and c_get_periods_2 cursors are added to be based on regular payment date */
821:
822: cursor c_get_periods_1n3
823: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
824: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
825: c_start_date in date,
826: c_end_date in date)
827: is

Line 844: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,

840: AND ptp.payroll_id = c_payroll_id
841: AND ptp.regular_payment_date BETWEEN c_start_date AND c_end_date; -- bug12753997
842:
843: cursor c_get_periods_2
844: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
845: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
846: c_start_date in date,
847: c_end_date in date)
848: is

Line 878: c_business_group_id in hr_all_organization_units.organization_id%TYPE,

874:
875: /* Bug#4467198 - Use the below cursor to check if this is the first for the assignment in this year*/
876:
877: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
878: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
879: c_start_date in date,
880: c_end_date in date)
881: IS
882: SELECT count(paa.assignment_action_id)

Line 4509: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,

4505: END;
4506:
4507: PROCEDURE upgrade_tax_scale(errbuf out NOCOPY varchar2,
4508: retcode out NOCOPY varchar2,
4509: p_business_group_id in HR_ALL_ORGANIZATION_UNITS.organization_id%type,
4510: p_mode in varchar2)
4511: IS
4512:
4513: error_code number;