APPS.PAY_MX_FF_UDFS dependencies on PER_ALL_ASSIGNMENTS_F

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

936: END Work_Sch_Total_Hours_or_Days;
937:
938: --
939:
940: FUNCTION get_idw (p_assignment_id per_all_assignments_f.assignment_id%TYPE,
941: p_tax_unit_id hr_organization_units.organization_id%TYPE,
942: p_effective_date DATE,
943: p_mode VARCHAR2,
944: p_fixed_idw OUT NOCOPY NUMBER,

Line 956: FROM per_all_assignments_f a,

952: a.location_id,
953: a.payroll_id,
954: a.business_group_id,
955: a.person_id
956: FROM per_all_assignments_f a,
957: per_all_assignments_f b
958: WHERE b.person_id = a.person_id
959: AND b.assignment_id = p_assignment_id
960: AND p_effective_date BETWEEN a.effective_start_date

Line 957: per_all_assignments_f b

953: a.payroll_id,
954: a.business_group_id,
955: a.person_id
956: FROM per_all_assignments_f a,
957: per_all_assignments_f b
958: WHERE b.person_id = a.person_id
959: AND b.assignment_id = p_assignment_id
960: AND p_effective_date BETWEEN a.effective_start_date
961: AND a.effective_end_date

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

1052: ln_basepay_rate NUMBER;
1053: lv_basepay_rate_name hr_lookups.meaning%TYPE;
1054: lv_fixedidw_rate_name hr_lookups.meaning%TYPE;
1055:
1056: FUNCTION get_fixed_idw (p_asg_id per_all_assignments_f.assignment_id%TYPE,
1057: p_calculation_date DATE,
1058: p_name VARCHAR2,
1059: p_contract_name VARCHAR2)
1060: RETURN NUMBER IS