[Home] [Help]
1343: -- Function to calculate the Normal Gross Earnings for a given assignment
1344: --
1345: FUNCTION CALCULATE_TERM_ASG_NGE
1346: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1347: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
1348: p_date_earned in date,
1349: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
1350: p_assignment_action_id IN number, /*Bug 4538463*/
1351: p_payroll_id IN NUMBER, /*Bug 4538463*/
1345: FUNCTION CALCULATE_TERM_ASG_NGE
1346: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1347: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
1348: p_date_earned in date,
1349: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
1350: p_assignment_action_id IN number, /*Bug 4538463*/
1351: p_payroll_id IN NUMBER, /*Bug 4538463*/
1352: p_termination_date in date,
1353: p_hire_date in date,
1402: -- Assignment Action ID for the corresponding LE.
1403: -----------------------------------------------------------------------
1404: CURSOR c_get_prev_year_max_asg_act_id
1405: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1406: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
1407: c_fin_start_date in date,
1408: c_fin_end_date in date)
1409: IS
1410: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id
1432:
1433: /*Bug 2610141 - Cursor introduced to give the maxmimum assignment action id of previous legal employer*/
1434: CURSOR c_get_pre_le_max_asg_act_id
1435: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1436: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
1437: c_fin_start_date in date,
1438: c_fin_end_date in date)
1439: IS
1440: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date
1471: to count number of pay periods between greatest of (employee's hire date, financial year start date,
1472: Legal Employer start date) and current period end date*/
1473:
1474: cursor c_get_periods
1475: (c_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
1476: c_payroll_id in pay_payrolls_f.payroll_id%TYPE,
1477: c_start_date in date,
1478: c_end_date in date)
1479: is
1504: WHERE paa.assignment_action_id = p_assignment_action_id
1505: AND ppa.payroll_action_id = paa.payroll_action_id;
1506:
1507: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
1508: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
1509: c_start_date in date,
1510: c_end_date in date)
1511: IS
1512: SELECT count(paa.assignment_action_id)
1917: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number
1918: and not to_number.
1919: */
1920:
1921: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE
1922: ,p_date_paid IN DATE
1923: ,p_user_table IN VARCHAR2
1924: ,p_amount IN NUMBER
1925: ,p_med_levy IN NUMBER) IS
2556: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number
2557: and not to_number.
2558: */
2559:
2560: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE
2561: ,p_date_paid IN DATE
2562: ,p_user_table IN VARCHAR2
2563: ,p_amount IN NUMBER
2564: ,p_med_levy IN NUMBER) IS
3685: ,p_included_under_cap OUT NOCOPY NUMBER
3686: )
3687: RETURN NUMBER IS
3688:
3689: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE
3690: ,p_date_paid IN DATE
3691: ,p_user_table IN VARCHAR2
3692: ,p_amount IN NUMBER
3693: ,p_med_levy IN NUMBER) IS