APPS.PAY_MX_FF_UDFS dependencies on PER_ALL_ASSIGNMENTS_F

Line 960: FUNCTION get_idw(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

956: code behave normally with old logic and it doesn't check for the manual input values.
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,

Line 1089: FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,

1085: END; /* get_idw */
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,

Line 1105: FROM per_all_assignments_f a,

1101: a.location_id,
1102: a.payroll_id,
1103: a.business_group_id,
1104: a.person_id
1105: FROM per_all_assignments_f a,
1106: per_all_assignments_f b
1107: WHERE b.person_id = a.person_id
1108: AND b.assignment_id = p_assignment_id
1109: AND p_effective_date BETWEEN a.effective_start_date

Line 1106: per_all_assignments_f b

1102: a.payroll_id,
1103: a.business_group_id,
1104: a.person_id
1105: FROM per_all_assignments_f a,
1106: per_all_assignments_f b
1107: WHERE b.person_id = a.person_id
1108: AND b.assignment_id = p_assignment_id
1109: AND p_effective_date BETWEEN a.effective_start_date
1110: AND a.effective_end_date

Line 1208: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,

1204: ln_basepay_rate NUMBER;
1205: lv_basepay_rate_name hr_lookups.meaning%TYPE;
1206: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;
1207:
1208: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,
1209: p_calculation_date DATE,
1210: p_name VARCHAR2,
1211: p_contract_name VARCHAR2)
1212: RETURN NUMBER IS