[Home] [Help]
957:
958: */
959:
960: FUNCTION get_idw(p_assignment_id per_all_assignments_f.assignment_id%TYPE,
961: p_tax_unit_id hr_organization_units.organization_id%TYPE,
962: p_effective_date DATE,
963: p_payroll_action_id NUMBER,
964: p_mode VARCHAR2,
965: p_fixed_idw OUT NOCOPY NUMBER,
1086:
1087: /* old get_idw function */
1088: ----------
1089: FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
1090: p_tax_unit_id hr_organization_units.organization_id%TYPE,
1091: p_effective_date DATE,
1092: p_mode VARCHAR2,
1093: p_fixed_idw OUT NOCOPY NUMBER,
1094: p_variable_idw OUT NOCOPY NUMBER)
1128: AND pa.effective_date BETWEEN cp_idw_start_date AND cp_idw_report_date
1129: ORDER BY aa.action_sequence desc;
1130:
1131: -- cursor to get the IDW Calc method
1132: CURSOR c_get_idw_calc_method (cp_org_id hr_organization_units.organization_id%TYPE,
1133: cp_eff_date DATE )
1134: IS
1135: select hoi.org_information10
1136: from hr_organization_units hou,
1132: CURSOR c_get_idw_calc_method (cp_org_id hr_organization_units.organization_id%TYPE,
1133: cp_eff_date DATE )
1134: IS
1135: select hoi.org_information10
1136: from hr_organization_units hou,
1137: hr_organization_information hoi
1138: where hou.organization_id = cp_org_id
1139: and hoi.org_information_context ='MX_SOC_SEC_DETAILS'
1140: and hou.organization_id = hoi.organization_id
2009: BUSINESS_GROUP_ID
2010: */
2011: FUNCTION GET_TAX_BALANCE(
2012: p_assignment_action_id NUMBER,
2013: p_tax_unit_id hr_organization_units.organization_id%TYPE,
2014: p_effective_date DATE,
2015: p_payroll_action_id NUMBER,
2016: p_business_group_id NUMBER,
2017: p_entity_name varchar2)