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 239: pay_payroll_actions ppa

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
243: AND ppa.effective_date BETWEEN paf.effective_start_date

Line 253: pay_payroll_actions ppa

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

Line 882: pay_payroll_actions ppa

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
886: AND paa.assignment_action_id = p_ctx_assignment_action_id

Line 900: pay_payroll_actions ppa

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
902: AND ppa.payroll_action_id = ptoa.payroll_action_id
903: AND ptoa.object_id = paf.assignment_id
904: AND ptoa.object_type = 'ASG'

Line 1309: pay_payroll_actions ppa

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 =
1313: (SELECT max(paa_prev.action_sequence)

Line 1315: , pay_payroll_actions ppa1

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

Line 1318: , pay_payroll_actions ppa_prev

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
1321: AND ppa1.payroll_action_id = paa1.payroll_action_id
1322: AND ppa1.effective_date BETWEEN ptp.start_date

Line 1335: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

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;
1339: l_proc_name VARCHAR2(100);

Line 1808: lv_action_type pay_payroll_actions.action_type%type;

1804: ln_isr_prop_fact NUMBER;
1805: ln_le_worked_days NUMBER;
1806: /* lv_calc_mode VARCHAR2(20);
1807: lv_process VARCHAR2(20);
1808: lv_action_type pay_payroll_actions.action_type%type;
1809:
1810: CURSOR csr_get_process_type IS
1811: SELECT action_type,
1812: pay_mx_utility.get_legi_param_val('CALC_MODE',

Line 1816: FROM pay_payroll_actions

1812: pay_mx_utility.get_legi_param_val('CALC_MODE',
1813: legislative_parameters),
1814: pay_mx_utility.get_legi_param_val('PROCESS',
1815: legislative_parameters)
1816: FROM pay_payroll_actions
1817: WHERE payroll_action_id = p_payroll_action_id;*/
1818:
1819: CURSOR csr_get_payroll_id IS
1820: SELECT payroll_id,effective_start_date

Line 1839: pay_payroll_actions ppa

1835: CURSOR csr_date_earned IS
1836: SELECT ppa.effective_date l_date_paid,
1837: ptp.end_date l_date_earned
1838: FROM per_time_periods ptp,
1839: pay_payroll_actions ppa
1840: WHERE ppa.payroll_action_id = p_payroll_action_id
1841: AND ppa.time_period_id = ptp.time_period_id;
1842:
1843: --Added for fix 6933775.

Line 1848: pay_payroll_actions ppa,

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
1852: AND ptp.time_period_id = ppa.time_period_id

Line 2227: from pay_payroll_actions ppa,

2223: exit when csr_get_period_count_in_month%NOTFOUND;
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

Line 2540: ,pay_payroll_actions ppa

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')
2544: AND ppa.date_earned <=P_CTX_DATE_EARNED;

Line 2645: ,pay_payroll_actions ppa

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'
2649: AND ppa.date_earned BETWEEN p_start_date AND p_end_date;

Line 2670: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

2666:
2667:
2668: l_proc_name VARCHAR2(100);
2669: l_flag VARCHAR2(4);
2670: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
2671: l_end_date DATE;
2672: l_start_date DATE;
2673: l_hire_date DATE;
2674: l_termination_date DATE;