[Home] [Help]
933: /* Get the details of the ETP Continuous Service Date and Pre/Post Days
934: if Entered for the calculation. These details if provided by the user
935: will be used in the ETP payments calculation. */
936:
937: cursor c_get_etp_information(c_assignment_id per_all_assignments_f.assignment_id%TYPE)
938: is
939: select peev.screen_entry_value,
940: peev1.screen_entry_value,
941: to_date(peev2.screen_entry_value,'YYYY/MM/DD HH24:MI:SS')
1246: -- Bug#3263690 - NGE calculation Enhancement.
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*/
1305: -- If there exists any LE changes, then it gets the max
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
1321: (
1322: SELECT MAX(paa.action_sequence)
1323: FROM pay_assignment_actions paa,
1324: pay_payroll_actions ppa,
1325: per_all_assignments_f paaf
1326: WHERE ppa.business_group_id = c_business_group_id
1327: AND paaf.assignment_id = c_assignment_id
1328: AND paa.assignment_id = paaf.assignment_id
1329: AND ppa.payroll_action_id = paa.payroll_action_id
1335: ORDER BY date_earned desc;
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
1351: (
1352: SELECT MAX(paa.action_sequence)
1353: FROM pay_assignment_actions paa,
1354: pay_payroll_actions ppa,
1355: per_all_assignments_f paaf
1356: WHERE ppa.business_group_id = c_business_group_id
1357: AND paaf.assignment_id = c_assignment_id
1358: AND paa.assignment_id = paaf.assignment_id
1359: AND ppa.payroll_action_id = paa.payroll_action_id
1407: pay_assignment_actions paa
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
2019: -- RETURNS: Preservation Age
2020: -- IN : Assignment Id
2021: -- : Date Earned
2022: FUNCTION au_check_trans
2023: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2024: p_date_earned IN DATE
2025: )
2026: RETURN VARCHAR2 IS
2027: