APPS.PAY_AU_TERMINATIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1251: p_business_group_id in hr_all_organization_units.organization_id%TYPE,

1247: -- Function to calculate the Normal Gross Earnings for a given assignment
1248: --
1249: FUNCTION CALCULATE_TERM_ASG_NGE
1250: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1251: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
1252: p_date_earned in date,
1253: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
1254: p_assignment_action_id IN number, /*Bug 4538463*/
1255: p_payroll_id IN NUMBER, /*Bug 4538463*/

Line 1253: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,

1249: FUNCTION CALCULATE_TERM_ASG_NGE
1250: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1251: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
1252: p_date_earned in date,
1253: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
1254: p_assignment_action_id IN number, /*Bug 4538463*/
1255: p_payroll_id IN NUMBER, /*Bug 4538463*/
1256: p_termination_date in date,
1257: p_hire_date in date,

Line 1310: c_business_group_id in hr_all_organization_units.organization_id%TYPE,

1306: -- Assignment Action ID for the corresponding LE.
1307: -----------------------------------------------------------------------
1308: CURSOR c_get_prev_year_max_asg_act_id
1309: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1310: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
1311: c_fin_start_date in date,
1312: c_fin_end_date in date)
1313: IS
1314: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id

Line 1340: c_business_group_id in hr_all_organization_units.organization_id%TYPE,

1336:
1337: /*Bug 2610141 - Cursor introduced to give the maxmimum assignment action id of previous legal employer*/
1338: CURSOR c_get_pre_le_max_asg_act_id
1339: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1340: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
1341: c_fin_start_date in date,
1342: c_fin_end_date in date)
1343: IS
1344: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date

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

1375: to count number of pay periods between greatest of (employee's hire date, financial year start date,
1376: Legal Employer start date) and current period end date*/
1377:
1378: cursor c_get_periods
1379: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
1380: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
1381: c_start_date in date,
1382: c_end_date in date)
1383: is

Line 1412: c_business_group_id in hr_all_organization_units.organization_id%TYPE,

1408: WHERE paa.assignment_action_id = p_assignment_action_id
1409: AND ppa.payroll_action_id = paa.payroll_action_id;
1410:
1411: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1412: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
1413: c_start_date in date,
1414: c_end_date in date)
1415: IS
1416: SELECT count(paa.assignment_action_id)

Line 1809: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE

1805: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number
1806: and not to_number.
1807: */
1808:
1809: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE
1810: ,p_date_paid IN DATE
1811: ,p_user_table IN VARCHAR2
1812: ,p_amount IN NUMBER
1813: ,p_med_levy IN NUMBER) IS