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_AU_TERMINATIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 627: from pay_assignment_actions ASGT_ACTION

623: from pay_run_results RESULT
624: where result.source_id = l_source_id --Bug 3306112
625: and result.status <> 'U'
626: and exists ( select 1
627: from pay_assignment_actions ASGT_ACTION
628: , pay_payroll_actions PAY_ACTION
629: , per_time_periods PERIOD
630: where result.assignment_action_id = asgt_action.assignment_action_id
631: and asgt_action.payroll_action_id = pay_action.payroll_action_id

Line 1384: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;

1380:
1381:
1382: -- Variable to store the maximum previous year assignment action id and its corresponding
1383: -- tax_unit_id (legal Employer).
1384: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1385: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1386:
1387:
1388: -- Total Earnings variable

Line 1385: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

1381:
1382: -- Variable to store the maximum previous year assignment action id and its corresponding
1383: -- tax_unit_id (legal Employer).
1384: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1385: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1386:
1387:
1388: -- Total Earnings variable
1389: --

Line 1411: FROM pay_assignment_actions paa

1407: c_fin_start_date in date,
1408: c_fin_end_date in date)
1409: IS
1410: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id
1411: FROM pay_assignment_actions paa
1412: ,pay_payroll_actions ppa
1413: WHERE paa.assignment_id = c_assignment_id
1414: and ppa.payroll_action_id = paa.payroll_action_id
1415: and ppa.business_group_id = c_business_group_id

Line 1419: FROM pay_assignment_actions paa,

1415: and ppa.business_group_id = c_business_group_id
1416: AND paa.action_sequence in
1417: (
1418: SELECT MAX(paa.action_sequence)
1419: FROM pay_assignment_actions paa,
1420: pay_payroll_actions ppa,
1421: per_all_assignments_f paaf
1422: WHERE ppa.business_group_id = c_business_group_id
1423: AND paaf.assignment_id = c_assignment_id

Line 1441: FROM pay_assignment_actions paa

1437: c_fin_start_date in date,
1438: c_fin_end_date in date)
1439: IS
1440: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date
1441: FROM pay_assignment_actions paa
1442: ,pay_payroll_actions ppa
1443: WHERE paa.assignment_id = c_assignment_id
1444: and ppa.payroll_action_id = paa.payroll_action_id
1445: and ppa.business_group_id = c_business_group_id

Line 1449: FROM pay_assignment_actions paa,

1445: and ppa.business_group_id = c_business_group_id
1446: AND paa.action_sequence in
1447: (
1448: SELECT MAX(paa.action_sequence)
1449: FROM pay_assignment_actions paa,
1450: pay_payroll_actions ppa,
1451: per_all_assignments_f paaf
1452: WHERE ppa.business_group_id = c_business_group_id
1453: AND paaf.assignment_id = c_assignment_id

Line 1503: pay_assignment_actions paa

1499: CURSOR c_get_payroll_effective_date
1500: IS
1501: SELECT ppa.effective_date
1502: FROM pay_payroll_actions ppa,
1503: pay_assignment_actions paa
1504: WHERE paa.assignment_action_id = p_assignment_action_id
1505: AND ppa.payroll_action_id = paa.payroll_action_id;
1506:
1507: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,

Line 1513: FROM pay_assignment_actions paa,

1509: c_start_date in date,
1510: c_end_date in date)
1511: IS
1512: SELECT count(paa.assignment_action_id)
1513: FROM pay_assignment_actions paa,
1514: pay_payroll_actions ppa,
1515: per_assignments_f paf
1516: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
1517: AND ppa.business_group_id = c_business_group_id

Line 2240: from pay_assignment_actions paa,

2236:
2237: cursor c_max_asg_action_id (c_year_start date
2238: ,c_year_end date) is
2239: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
2240: from pay_assignment_actions paa,
2241: pay_payroll_actions ppa,
2242: per_assignments_f paf
2243: where paa.assignment_id = paf.assignment_id
2244: and paf.assignment_id = p_assignment_id

Line 2254: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS

2250: and paa.action_status = 'C'
2251: and paa.tax_unit_id = p_tax_unit_id;
2252:
2253: cursor csr_get_bal_value (c_balance_name varchar2,
2254: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
2255: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
2256: ,c_max_assignment_action_id
2257: ,p_tax_unit_id
2258: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)

Line 2277: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2273: l_year_end_atd date;
2274: l_year_start_paid date;
2275: l_year_end_paid date;
2276: l_count_year number;
2277: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2278: l_add number := 0;
2279: l_prev_etp number := 0;
2280: l_tot_prev_etp number := 0;
2281: l_max number := 0;

Line 2593: from pay_assignment_actions paa,

2589:
2590: cursor c_max_asg_action_id (c_year_start date
2591: ,c_year_end date) is
2592: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
2593: from pay_assignment_actions paa,
2594: pay_payroll_actions ppa,
2595: per_assignments_f paf
2596: where paa.assignment_id = paf.assignment_id
2597: and paf.assignment_id = p_assignment_id

Line 2607: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS

2603: and paa.action_status = 'C'
2604: and paa.tax_unit_id = p_tax_unit_id;
2605:
2606: cursor csr_get_bal_value (c_balance_name varchar2,
2607: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
2608: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
2609: ,c_max_assignment_action_id
2610: ,p_tax_unit_id
2611: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)

Line 2636: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2632: l_year_end_paid date;
2633: l_count_year number := 0;
2634: l_add number := 0;
2635: l_tot_prev_etp number:= 0;
2636: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2637:
2638:
2639: l_etp_tax_notran_noppt_ytd number;
2640: l_etp_tax_notran_ppt_ytd number;

Line 3229: pay_assignment_actions pac,

3225: 'Statutory Paid Parental Leave Payment' ,to_date(peev1.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS'))),0)
3226: from
3227: per_time_periods ptp,
3228: per_all_assignments_f paa,
3229: pay_assignment_actions pac,
3230: pay_payroll_actions ppa,
3231: pay_element_entries_f pee,
3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,

Line 3398: from pay_assignment_actions paa,

3394:
3395: cursor c_max_asg_action_id (c_year_start date
3396: ,c_year_end date) is
3397: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3398: from pay_assignment_actions paa,
3399: pay_payroll_actions ppa,
3400: per_assignments_f paf
3401: where paa.assignment_id = paf.assignment_id
3402: and paf.assignment_id = p_assignment_id

Line 3412: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS

3408: and paa.action_status = 'C'
3409: and paa.tax_unit_id = p_tax_unit_id;
3410:
3411: cursor csr_get_bal_value (c_balance_name varchar2,
3412: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
3413: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3414: ,c_max_assignment_action_id
3415: ,p_tax_unit_id
3416: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)

Line 3435: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

3431: l_year_end_atd date;
3432: l_year_start_paid date;
3433: l_year_end_paid date;
3434: l_count_year number;
3435: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
3436: l_add number := 0;
3437: l_prev_etp number := 0;
3438: l_tot_prev_etp number := 0;
3439: l_max number := 0;

Line 3723: from pay_assignment_actions paa,

3719: cursor c_max_asg_action_id (c_year_start date
3720: ,c_year_end date
3721: ,c_assignment_id number) is
3722: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3723: from pay_assignment_actions paa,
3724: pay_payroll_actions ppa,
3725: per_assignments_f paf
3726: where paa.assignment_id = paf.assignment_id
3727: and paf.assignment_id = c_assignment_id

Line 3737: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS

3733: and paa.action_status = 'C'
3734: and paa.tax_unit_id = p_tax_unit_id;
3735:
3736: cursor csr_get_bal_value (c_balance_name varchar2,
3737: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
3738: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3739: ,c_max_assignment_action_id
3740: ,p_tax_unit_id
3741: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)

Line 3790: from pay_assignment_actions paa,

3786: cursor c_rehire_max_asg_action_id (c_year_start date
3787: ,c_year_end date
3788: ,c_assignment_id number) is
3789: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3790: from pay_assignment_actions paa,
3791: pay_payroll_actions ppa,
3792: per_assignments_f paf
3793: where paa.assignment_id = paf.assignment_id
3794: and paf.assignment_id = c_assignment_id

Line 3803: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS

3799: and ppa.effective_date between paf.effective_start_date and paf.effective_end_date
3800: and paa.action_status = 'C' ;
3801:
3802: cursor csr_rehire_get_bal_value (c_balance_name varchar2,
3803: c_max_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
3804: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3805: ,c_max_assignment_action_id
3806: ,NULL
3807: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)

Line 3853: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

3849: l_year_start_paid date;
3850: l_year_end_paid date;
3851: l_count_year number;
3852: l_add number;
3853: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
3854:
3855: l_etp_tax_excluded_ytd number;
3856: l_etp_tax_included_ytd number;
3857: l_etp_tax_excluded_prev number;