APPS.PAY_MX_TAX_FUNCTIONS dependencies on PER_ASSIGNMENTS_F

Line 237: FROM per_assignments_f paf,

233: SELECT paf.soft_coding_keyflex_id,
234: paf.location_id,
235: ppa.effective_date,
236: paf.business_group_id
237: FROM per_assignments_f paf,
238: pay_assignment_actions paa,
239: pay_payroll_actions ppa
240: WHERE paf.assignment_id = paa.assignment_id
241: AND paa.payroll_action_id = ppa.payroll_action_id

Line 251: FROM per_assignments_f paf,

247: SELECT paf.soft_coding_keyflex_id,
248: paf.location_id,
249: ppa.effective_date,
250: paf.business_group_id
251: FROM per_assignments_f paf,
252: pay_temp_object_actions ptoa,
253: pay_payroll_actions ppa
254: WHERE paf.assignment_id = ptoa.object_id
255: AND ptoa.payroll_action_id = ppa.payroll_action_id

Line 897: FROM per_assignments_f paf,

893: SELECT TRUNC(ptp.end_date - ptp.start_date) + 1 days,
894: paf.payroll_id,
895: -- paa.tax_unit_id,
896: paf.assignment_id
897: FROM per_assignments_f paf,
898: per_time_periods ptp,
899: pay_temp_object_actions ptoa,
900: pay_payroll_actions ppa
901: WHERE ptp.payroll_id = paf.payroll_id

Line 914: FROM per_assignments_f paf

910:
911: CURSOR get_person_id ( cp_assignment_id NUMBER
912: ,cp_effective_date DATE) IS
913: SELECT person_id
914: FROM per_assignments_f paf
915: WHERE paf.assignment_id = cp_assignment_id
916: AND cp_effective_date BETWEEN paf.effective_start_date
917: AND paf.effective_end_date;
918:

Line 2628: ,per_assignments_f paf

2624: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
2625: ||'/'||hoi.org_information8),
2626: paf.person_id
2627: FROM hr_organization_information hoi
2628: ,per_assignments_f paf
2629: WHERE hoi.organization_id =
2630: hr_mx_utility.get_legal_employer(paf.business_group_id,
2631: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
2632: paf.location_id