eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PER_ASSIGNMENTS

Line 283: FROM per_assignments_f paf,

279: SELECT paf.soft_coding_keyflex_id,
280: paf.location_id,
281: ppa.effective_date,
282: paf.business_group_id
283: FROM per_assignments_f paf,
284: pay_assignment_actions paa,
285: pay_payroll_actions ppa
286: WHERE paf.assignment_id = paa.assignment_id
287: AND paa.payroll_action_id = ppa.payroll_action_id

Line 297: FROM per_assignments_f paf,

293: SELECT paf.soft_coding_keyflex_id,
294: paf.location_id,
295: ppa.effective_date,
296: paf.business_group_id
297: FROM per_assignments_f paf,
298: pay_temp_object_actions ptoa,
299: pay_payroll_actions ppa
300: WHERE paf.assignment_id = ptoa.object_id
301: AND ptoa.payroll_action_id = ppa.payroll_action_id

Line 312: FROM per_assignments_f paf,

308: SELECT paf.soft_coding_keyflex_id,
309: paf.location_id,
310: ppa.effective_date,
311: paf.business_group_id
312: FROM per_assignments_f paf,
313: pay_temp_object_actions ptoa,
314: pay_payroll_actions ppa
315: WHERE paf.assignment_id = ptoa.object_id
316: AND ptoa.payroll_action_id = ppa.payroll_action_id

Line 966: FROM per_assignments_f paf,

962: SELECT TRUNC(ptp.end_date - ptp.start_date) + 1 days,
963: paf.payroll_id,
964: -- paa.tax_unit_id,
965: paf.assignment_id
966: FROM per_assignments_f paf,
967: per_time_periods ptp,
968: pay_temp_object_actions ptoa,
969: pay_payroll_actions ppa
970: WHERE ptp.payroll_id = paf.payroll_id

Line 986: FROM per_assignments_f paf,

982: SELECT TRUNC(ptp.end_date - ptp.start_date) + 1 days,
983: paf.payroll_id,
984: -- paa.tax_unit_id,
985: paf.assignment_id
986: FROM per_assignments_f paf,
987: per_time_periods ptp,
988: pay_temp_object_actions ptoa,
989: pay_payroll_actions ppa
990: WHERE ptp.payroll_id = paf.payroll_id

Line 1003: FROM per_assignments_f paf

999:
1000: CURSOR get_person_id ( cp_assignment_id NUMBER
1001: ,cp_effective_date DATE) IS
1002: SELECT person_id
1003: FROM per_assignments_f paf
1004: WHERE paf.assignment_id = cp_assignment_id
1005: AND cp_effective_date BETWEEN paf.effective_start_date
1006: AND paf.effective_end_date;
1007:

Line 1956: FROM per_assignments

1952: WHERE payroll_action_id = p_payroll_action_id;*/
1953:
1954: CURSOR csr_get_payroll_id IS /* bug#8932102 */
1955: SELECT payroll_id
1956: FROM per_assignments
1957: WHERE assignment_id = P_ASSIGNMENT_ID;
1958:
1959: CURSOR csr_get_hire_date IS /* bug#8932102 */
1960: SELECT min(effective_start_date)

Line 2023: FROM per_assignments_f paf,

2019: AND TO_CHAR(l_date_earned,'yyyymmdd') = TO_CHAR(end_date,'yyyymmdd');
2020:
2021: CURSOR csr_get_compute_subsidy_flag IS /*bug#8438155*/
2022: SELECT nvl(hsck.SEGMENT11,'Y')
2023: FROM per_assignments_f paf,
2024: pay_assignment_actions paa,
2025: pay_payroll_actions ppa,
2026: hr_soft_coding_keyflex hsck
2027: WHERE paf.assignment_id = paa.assignment_id

Line 2068: 2. Table reference per_assignments_f has been changed to per_assignments in

2064: 1. Seperated ld_hire_date from cursor csr_get_payroll_id
2065: and created seperate cursor to fetch ld_hire_date, this is because
2066: ld_hire_date will be wrong when the per_all_people_f table has
2067: multiple date effective entries
2068: 2. Table reference per_assignments_f has been changed to per_assignments in
2069: cursor csr_get_payroll_id to get latest payroll_id for the assignment*/
2070:
2071: OPEN csr_get_payroll_id; /*bug#8932102 */
2072: FETCH csr_get_payroll_id INTO ln_payroll_id;

Line 2289: 2. Table reference per_assignments_f has been changed to per_assignments in

2285: 1. Seperated ld_hire_date from cursor csr_get_payroll_id
2286: and created seperate cursor to fetch ld_hire_date, this is because
2287: ld_hire_date will be wrong when the per_all_people_f table has
2288: multiple date effective entries
2289: 2. Table reference per_assignments_f has been changed to per_assignments in
2290: cursor csr_get_payroll_id*/
2291:
2292:
2293: OPEN csr_get_payroll_id; /*bug#8932102 */

Line 2733: FROM per_assignments

2729: WHERE payroll_action_id = p_payroll_action_id;*/
2730:
2731: CURSOR csr_get_payroll_id IS /* bug#8932102 */
2732: SELECT payroll_id
2733: FROM per_assignments
2734: WHERE assignment_id = P_ASSIGNMENT_ID;
2735:
2736: CURSOR csr_get_hire_date IS /* bug#8932102 */
2737: SELECT min(effective_start_date)

Line 2856: FROM per_periods_of_service pps , per_assignments_f paf

2852: AND l_date_paid BETWEEN start_date AND end_date;
2853:
2854: CURSOR csr_get_act_hire_date IS
2855: SELECT MIN(pps.date_start)
2856: FROM per_periods_of_service pps , per_assignments_f paf
2857: WHERE paf.assignment_id = P_ASSIGNMENT_ID
2858: AND pps.person_id = paf.person_id;
2859:
2860: CURSOR csr_get_compute_subsidy_flag IS /*bug#8438155*/

Line 2862: FROM per_assignments_f paf,

2858: AND pps.person_id = paf.person_id;
2859:
2860: CURSOR csr_get_compute_subsidy_flag IS /*bug#8438155*/
2861: SELECT nvl(hsck.SEGMENT11,'Y')
2862: FROM per_assignments_f paf,
2863: pay_assignment_actions paa,
2864: pay_payroll_actions ppa,
2865: hr_soft_coding_keyflex hsck
2866: WHERE paf.assignment_id = paa.assignment_id

Line 3926: ,per_assignments_f paf

3922: fnd_date.canonical_to_date(TO_CHAR(P_CTX_DATE_EARNED,'YYYY')
3923: ||'/'||hoi.org_information8),
3924: paf.person_id
3925: FROM hr_organization_information hoi
3926: ,per_assignments_f paf
3927: WHERE hoi.organization_id =
3928: hr_mx_utility.get_legal_employer(paf.business_group_id,
3929: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3930: paf.location_id