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.

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 285: pay_payroll_actions ppa

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
288: AND paa.assignment_action_id = p_asact_id
289: AND ppa.effective_date BETWEEN paf.effective_start_date

Line 299: pay_payroll_actions ppa

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
302: AND ptoa.object_action_id = p_asact_id
303: AND ptoa.object_type = 'ASG'

Line 314: pay_payroll_actions ppa

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
317: AND ptoa.object_action_id = p_asact_id
318: AND ptoa.object_type = 'ASG'

Line 951: pay_payroll_actions ppa

947: paa.assignment_id
948: FROM pay_payrolls_f ppf,
949: per_time_periods ptp,
950: pay_assignment_actions paa,
951: pay_payroll_actions ppa
952: WHERE ptp.payroll_id = ppf.payroll_id
953: AND ppf.payroll_id = ppa.payroll_id
954: AND ppa.payroll_action_id = paa.payroll_action_id
955: AND paa.assignment_action_id = p_ctx_assignment_action_id

Line 969: pay_payroll_actions ppa

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
971: AND ppa.payroll_action_id = ptoa.payroll_action_id
972: AND ptoa.object_id = paf.assignment_id
973: AND ptoa.object_type = 'ASG'

Line 989: pay_payroll_actions ppa

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
991: AND ppa.payroll_action_id = ptoa.payroll_action_id
992: AND ptoa.object_id = paf.assignment_id
993: AND ptoa.object_type = 'ASG'

Line 1443: pay_payroll_actions ppa

1439:
1440: CURSOR get_previous_assact IS
1441: SELECT paa.assignment_action_id
1442: FROM pay_assignment_actions paa,
1443: pay_payroll_actions ppa
1444: WHERE paa.assignment_id = p_ctx_assignment_id
1445: AND paa.payroll_action_id = ppa.payroll_action_id
1446: AND paa.action_sequence =
1447: (SELECT max(paa_prev.action_sequence)

Line 1449: , pay_payroll_actions ppa1

1445: AND paa.payroll_action_id = ppa.payroll_action_id
1446: AND paa.action_sequence =
1447: (SELECT max(paa_prev.action_sequence)
1448: FROM per_time_periods ptp
1449: , pay_payroll_actions ppa1
1450: , pay_assignment_actions paa1
1451: , per_time_periods ptp_prev
1452: , pay_payroll_actions ppa_prev
1453: , pay_assignment_actions paa_prev

Line 1452: , pay_payroll_actions ppa_prev

1448: FROM per_time_periods ptp
1449: , pay_payroll_actions ppa1
1450: , pay_assignment_actions paa1
1451: , per_time_periods ptp_prev
1452: , pay_payroll_actions ppa_prev
1453: , pay_assignment_actions paa_prev
1454: WHERE paa1.assignment_action_id = p_ctx_assignment_action_id
1455: AND ppa1.payroll_action_id = paa1.payroll_action_id
1456: AND ppa1.effective_date BETWEEN ptp.start_date

Line 1469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

1465: AND ppa_prev.effective_date BETWEEN ptp_prev.start_date
1466: AND ptp_prev.end_date);
1467:
1468: l_prev_assact pay_assignment_actions.assignment_action_id%TYPE;
1469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1470: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1471: l_counter NUMBER;
1472: l_balance_value NUMBER;
1473: l_proc_name VARCHAR2(100);

Line 1943: lv_action_type pay_payroll_actions.action_type%type;

1939: ln_le_worked_days NUMBER;
1940: l_compute_subsidy_flag CHAR(1); /*bug#8438155*/
1941: /* lv_calc_mode VARCHAR2(20);
1942: lv_process VARCHAR2(20);
1943: lv_action_type pay_payroll_actions.action_type%type;
1944:
1945: CURSOR csr_get_process_type IS
1946: SELECT action_type,
1947: pay_mx_utility.get_legi_param_val('CALC_MODE',

Line 1951: FROM pay_payroll_actions

1947: pay_mx_utility.get_legi_param_val('CALC_MODE',
1948: legislative_parameters),
1949: pay_mx_utility.get_legi_param_val('PROCESS',
1950: legislative_parameters)
1951: FROM pay_payroll_actions
1952: WHERE payroll_action_id = p_payroll_action_id;*/
1953:
1954: CURSOR csr_get_payroll_id IS /* bug#8932102 */
1955: SELECT payroll_id

Line 1980: pay_payroll_actions ppa

1976: CURSOR csr_date_earned IS
1977: SELECT ppa.effective_date l_date_paid,
1978: ptp.end_date l_date_earned
1979: FROM per_time_periods ptp,
1980: pay_payroll_actions ppa
1981: WHERE ppa.payroll_action_id = p_payroll_action_id
1982: AND ppa.time_period_id = ptp.time_period_id;
1983:
1984: --Added for fix 6933775.

Line 1989: pay_payroll_actions ppa,

1985: /*Cursor to get the first pay period start date for the assignment*/
1986: CURSOR csr_get_first_pay_date IS
1987: SELECT MIN(ptp.start_date)
1988: FROM pay_assignment_actions paa,
1989: pay_payroll_actions ppa,
1990: per_time_periods ptp
1991: WHERE paa.assignment_id = p_assignment_id
1992: AND paa.payroll_action_id = ppa.payroll_action_id
1993: AND ptp.time_period_id = ppa.time_period_id

Line 2025: pay_payroll_actions ppa,

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
2028: AND paa.payroll_action_id = ppa.payroll_action_id
2029: AND paa.assignment_action_id = p_assignment_action_id

Line 2421: from pay_payroll_actions ppa,

2417: exit when csr_get_period_count_in_month%NOTFOUND;
2418:
2419: select least(count(*),1)
2420: into ln_pre_date_paid
2421: from pay_payroll_actions ppa,
2422: pay_assignment_actions paa,
2423: per_time_periods ptp
2424: where ppa.payroll_action_id = paa.payroll_action_id
2425: and ptp.time_period_id = ppa.time_period_id

Line 2720: lv_action_type pay_payroll_actions.action_type%type;

2716: ln_ISR_calculated_ytd NUMBER;
2717:
2718: /* lv_calc_mode VARCHAR2(20);
2719: lv_process VARCHAR2(20);
2720: lv_action_type pay_payroll_actions.action_type%type;
2721:
2722: CURSOR csr_get_process_type IS
2723: SELECT action_type,
2724: pay_mx_utility.get_legi_param_val('CALC_MODE',

Line 2728: FROM pay_payroll_actions

2724: pay_mx_utility.get_legi_param_val('CALC_MODE',
2725: legislative_parameters),
2726: pay_mx_utility.get_legi_param_val('PROCESS',
2727: legislative_parameters)
2728: FROM pay_payroll_actions
2729: WHERE payroll_action_id = p_payroll_action_id;*/
2730:
2731: CURSOR csr_get_payroll_id IS /* bug#8932102 */
2732: SELECT payroll_id

Line 2757: pay_payroll_actions ppa

2753: CURSOR csr_date_earned IS
2754: SELECT ppa.effective_date l_date_paid,
2755: ptp.end_date l_date_earned
2756: FROM per_time_periods ptp,
2757: pay_payroll_actions ppa
2758: WHERE ppa.payroll_action_id = p_payroll_action_id
2759: AND ppa.time_period_id = ptp.time_period_id;
2760:
2761: --Added for fix 6933775.

Line 2766: pay_payroll_actions ppa,

2762: /*Cursor to get the first pay period start date for the assignment*/
2763: CURSOR csr_get_first_pay_date IS
2764: SELECT MIN(ptp.start_date)
2765: FROM pay_assignment_actions paa,
2766: pay_payroll_actions ppa,
2767: per_time_periods ptp
2768: WHERE paa.assignment_id = p_assignment_id
2769: AND paa.payroll_action_id = ppa.payroll_action_id
2770: AND ptp.time_period_id = ppa.time_period_id

Line 2864: pay_payroll_actions ppa,

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
2867: AND paa.payroll_action_id = ppa.payroll_action_id
2868: AND paa.assignment_action_id = p_assignment_action_id

Line 3244: from pay_payroll_actions ppa,

3240: exit when csr_get_period_count_in_month%NOTFOUND;
3241:
3242: select least(count(*),1)
3243: into ln_pre_date_paid
3244: from pay_payroll_actions ppa,
3245: pay_assignment_actions paa,
3246: per_time_periods ptp
3247: where ppa.payroll_action_id = paa.payroll_action_id
3248: and ptp.time_period_id = ppa.time_period_id

Line 3838: ,pay_payroll_actions ppa

3834: CURSOR c_assignment_action_id
3835: IS
3836: SELECT MAX(paa.assignment_action_id)
3837: FROM pay_assignment_actions paa
3838: ,pay_payroll_actions ppa
3839: WHERE paa.assignment_id =P_CTX_ASSIGNMENT_ID
3840: AND paa.payroll_action_id=ppa.payroll_action_id
3841: AND ppa.action_type in ('R','Q','I')
3842: AND ppa.date_earned <=P_CTX_DATE_EARNED;

Line 3943: ,pay_payroll_actions ppa

3939:
3940: CURSOR csr_get_form37_status (p_start_date date,p_end_date date) IS
3941: SELECT 'N'
3942: FROM pay_assignment_actions paa
3943: ,pay_payroll_actions ppa
3944: WHERE paa.payroll_action_id=ppa.payroll_action_id
3945: AND paa.assignment_id =P_CTX_ASSIGNMENT_ID
3946: AND ppa.report_type='ISR_TAX_FORMAT37'
3947: AND ppa.date_earned BETWEEN p_start_date AND p_end_date;

Line 3968: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

3964:
3965:
3966: l_proc_name VARCHAR2(100);
3967: l_flag VARCHAR2(4);
3968: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
3969: l_end_date DATE;
3970: l_start_date DATE;
3971: l_hire_date DATE;
3972: l_termination_date DATE;