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 169: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

165: legislation_info5 pay_mx_legislation_info_f.legislation_info5%TYPE,
166: legislation_info6 pay_mx_legislation_info_f.legislation_info6%TYPE);
167:
168: TYPE g_isr_balances_rec IS RECORD (
169: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
170: earnings_amt NUMBER,
171: exempt_amt NUMBER);
172:
173: TYPE g_leg_table IS TABLE OF g_leg_record INDEX BY BINARY_INTEGER;

Line 238: pay_assignment_actions paa,

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

Line 881: pay_assignment_actions paa,

877: paa.tax_unit_id,
878: paa.assignment_id
879: FROM pay_payrolls_f ppf,
880: per_time_periods ptp,
881: pay_assignment_actions paa,
882: pay_payroll_actions ppa
883: WHERE ptp.payroll_id = ppf.payroll_id
884: AND ppf.payroll_id = ppa.payroll_id
885: AND ppa.payroll_action_id = paa.payroll_action_id

Line 927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

923: l_high_exempt_factor pay_mx_earn_exemption_rules_f.high_exempt_factor%TYPE;
924: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
928: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
930: ln_person_id per_all_people_f.person_id%TYPE;
931: l_classification_id NUMBER;

Line 929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;

925: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
926: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
927: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
928: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
929: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
930: ln_person_id per_all_people_f.person_id%TYPE;
931: l_classification_id NUMBER;
932: l_hire_date DATE;
933: l_exempt_amount NUMBER;

Line 1308: FROM pay_assignment_actions paa,

1304: ) RETURN NUMBER AS
1305:
1306: CURSOR get_previous_assact IS
1307: SELECT paa.assignment_action_id
1308: FROM pay_assignment_actions paa,
1309: pay_payroll_actions ppa
1310: WHERE paa.assignment_id = p_ctx_assignment_id
1311: AND paa.payroll_action_id = ppa.payroll_action_id
1312: AND paa.action_sequence =

Line 1316: , pay_assignment_actions paa1

1312: AND paa.action_sequence =
1313: (SELECT max(paa_prev.action_sequence)
1314: FROM per_time_periods ptp
1315: , pay_payroll_actions ppa1
1316: , pay_assignment_actions paa1
1317: , per_time_periods ptp_prev
1318: , pay_payroll_actions ppa_prev
1319: , pay_assignment_actions paa_prev
1320: WHERE paa1.assignment_action_id = p_ctx_assignment_action_id

Line 1319: , pay_assignment_actions paa_prev

1315: , pay_payroll_actions ppa1
1316: , pay_assignment_actions paa1
1317: , per_time_periods ptp_prev
1318: , pay_payroll_actions ppa_prev
1319: , pay_assignment_actions paa_prev
1320: WHERE paa1.assignment_action_id = p_ctx_assignment_action_id
1321: AND ppa1.payroll_action_id = paa1.payroll_action_id
1322: AND ppa1.effective_date BETWEEN ptp.start_date
1323: AND ptp.end_date

Line 1334: l_prev_assact pay_assignment_actions.assignment_action_id%TYPE;

1330: AND ppa_prev.action_type IN ('R', 'Q', 'B')
1331: AND ppa_prev.effective_date BETWEEN ptp_prev.start_date
1332: AND ptp_prev.end_date);
1333:
1334: l_prev_assact pay_assignment_actions.assignment_action_id%TYPE;
1335: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1336: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1337: l_counter NUMBER;
1338: l_balance_value NUMBER;

Line 1847: FROM pay_assignment_actions paa,

1843: --Added for fix 6933775.
1844: /*Cursor to get the first pay period start date for the assignment*/
1845: CURSOR csr_get_first_pay_date IS
1846: SELECT MIN(ptp.start_date)
1847: FROM pay_assignment_actions paa,
1848: pay_payroll_actions ppa,
1849: per_time_periods ptp
1850: WHERE paa.assignment_id = p_assignment_id
1851: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2228: pay_assignment_actions paa,

2224:
2225: select least(count(*),1)
2226: into ln_pre_date_paid
2227: from pay_payroll_actions ppa,
2228: pay_assignment_actions paa,
2229: per_time_periods ptp
2230: where ppa.payroll_action_id = paa.payroll_action_id
2231: and ptp.time_period_id = ppa.time_period_id
2232: and paa.assignment_id = p_assignment_id

Line 2539: FROM pay_assignment_actions paa

2535:
2536: CURSOR c_assignment_action_id
2537: IS
2538: SELECT MAX(paa.assignment_action_id)
2539: FROM pay_assignment_actions paa
2540: ,pay_payroll_actions ppa
2541: WHERE paa.assignment_id =P_CTX_ASSIGNMENT_ID
2542: AND paa.payroll_action_id=ppa.payroll_action_id
2543: AND ppa.action_type in ('R','Q','I')

Line 2552: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2548: l_ignore NUMBER;
2549: l_pkg_value NUMBER;
2550: l_gross_earning NUMBER;
2551: l_bal_defined_id NUMBER;
2552: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2553: BEGIN
2554: l_flag :='N';
2555: l_ignore:=0;
2556: l_gross_earning:=0;

Line 2644: FROM pay_assignment_actions paa

2640: AND paf.effective_end_date;
2641:
2642: CURSOR csr_get_form37_status (p_start_date date,p_end_date date) IS
2643: SELECT 'N'
2644: FROM pay_assignment_actions paa
2645: ,pay_payroll_actions ppa
2646: WHERE paa.payroll_action_id=ppa.payroll_action_id
2647: AND paa.assignment_id =P_CTX_ASSIGNMENT_ID
2648: AND ppa.report_type='ISR_TAX_FORMAT37'