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_ASSIGNMENT_ACTIONS

Line 214: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

210: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
211: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
212:
213: TYPE g_isr_balances_rec IS RECORD (
214: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
215: earnings_amt NUMBER,
216: exempt_amt NUMBER);
217:
218: TYPE g_leg_table IS TABLE OF g_leg_record INDEX BY BINARY_INTEGER;

Line 284: pay_assignment_actions paa,

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
288: AND paa.assignment_action_id = p_asact_id

Line 950: pay_assignment_actions paa,

946: paa.tax_unit_id,
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

Line 1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1014: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1021: ln_person_id per_all_people_f.person_id%TYPE;
1022: l_classification_id NUMBER;

Line 1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;

1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1021: ln_person_id per_all_people_f.person_id%TYPE;
1022: l_classification_id NUMBER;
1023: l_hire_date DATE;
1024: l_exempt_amount NUMBER;

Line 1442: FROM pay_assignment_actions paa,

1438: ) RETURN NUMBER AS
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 =

Line 1450: , pay_assignment_actions paa1

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
1454: WHERE paa1.assignment_action_id = p_ctx_assignment_action_id

Line 1453: , pay_assignment_actions paa_prev

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
1457: AND ptp.end_date

Line 1468: l_prev_assact pay_assignment_actions.assignment_action_id%TYPE;

1464: AND ppa_prev.action_type IN ('R', 'Q', 'B')
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;

Line 1988: FROM pay_assignment_actions paa,

1984: --Added for fix 6933775.
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

Line 2024: pay_assignment_actions paa,

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

Line 2422: pay_assignment_actions paa,

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
2426: and paa.assignment_id = p_assignment_id

Line 2765: FROM pay_assignment_actions paa,

2761: --Added for fix 6933775.
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

Line 2863: pay_assignment_actions paa,

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

Line 3245: pay_assignment_actions paa,

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
3249: and paa.assignment_id = p_assignment_id

Line 3837: FROM pay_assignment_actions paa

3833:
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')

Line 3850: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

3846: l_ignore NUMBER;
3847: l_pkg_value NUMBER;
3848: l_gross_earning NUMBER;
3849: l_bal_defined_id NUMBER;
3850: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
3851: BEGIN
3852: l_flag :='N';
3853: l_ignore:=0;
3854: l_gross_earning:=0;

Line 3942: FROM pay_assignment_actions paa

3938: AND paf.effective_end_date;
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'