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_GB_EOY_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 311: pay_run_results prr

307: -- SCON while the Run Result still holds a valid SCON.
308: --
309: select prrv.result_value
310: from pay_run_result_values prrv,
311: pay_run_results prr
312: where prr.source_id = c_element_entry_id
313: and prr.element_type_id = g_ni_id
314: and prr.assignment_action_id = c_assignment_action_id
315: and prrv.run_result_id = prr.run_result_id

Line 3111: l_tax_run_result_id pay_run_results.run_result_id%TYPE;

3107: l_dummy NUMBER(1);
3108: l_index1 binary_integer;
3109: l_index2 binary_integer;
3110: --
3111: l_tax_run_result_id pay_run_results.run_result_id%TYPE;
3112: l_tax_paye_run_result_id pay_run_results.run_result_id%TYPE;
3113: --
3114: l_tax_code VARCHAR2(10);
3115: l_w1_m1_indicator VARCHAR2(1);

Line 3112: l_tax_paye_run_result_id pay_run_results.run_result_id%TYPE;

3108: l_index1 binary_integer;
3109: l_index2 binary_integer;
3110: --
3111: l_tax_run_result_id pay_run_results.run_result_id%TYPE;
3112: l_tax_paye_run_result_id pay_run_results.run_result_id%TYPE;
3113: --
3114: l_tax_code VARCHAR2(10);
3115: l_w1_m1_indicator VARCHAR2(1);
3116: l_previous_taxable_pay NUMBER(15);

Line 3346: pay_run_results prr

3342: AND run_result_id = (SELECT to_number(substr(max(lpad(to_char(act.action_sequence),15,'0')|| lpad(to_char(prr.run_result_id),19,'0')),16))
3343: FROM pay_payroll_Actions pact,
3344: pay_assignment_actions act,
3345: per_all_assignments_f paf,
3346: pay_run_results prr
3347: WHERE pact.payroll_Action_id = act.payroll_Action_id
3348: AND pact.effective_date BETWEEN g_start_year and g_end_year
3349: AND act.action_status = 'C'
3350: AND act.assignment_id = paf.assignment_id

Line 3451: ,pay_run_results rr

3447: rebate_emp
3448: FROM pay_balance_feeds_f feed
3449: ,pay_balance_types bal
3450: ,pay_run_result_values target
3451: ,pay_run_results rr
3452: ,pay_element_entry_values_f ev_scon
3453: ,pay_element_entry_values_f ev_cat
3454: ,pay_element_entries_f e_ni
3455: ,pay_element_links_f el_ni

Line 3560: FROM pay_run_results r

3556: BETWEEN scon.effective_start_date AND scon.effective_end_date;
3557: --
3558: cursor csr_tax_last_run(p_last_asg_action_id NUMBER) IS
3559: SELECT to_number(substr(max(source_type||lpad(to_char(run_result_id), 19, '0')),2)) -- gets indirect results if present else gets entry results
3560: FROM pay_run_results r
3561: WHERE r.element_type_id = g_paye_details_id
3562: AND r.status IN ('P', 'PA')
3563: AND r.assignment_action_id = p_last_asg_action_id;
3564: --

Line 3567: FROM pay_run_results r

3563: AND r.assignment_action_id = p_last_asg_action_id;
3564: --
3565: cursor csr_tax_last_paye_run(p_last_asg_action_id NUMBER) IS
3566: SELECT to_number(substr(max(source_type||lpad(to_char(run_result_id), 19, '0')),2)) -- gets indirect results if present else gets entry results
3567: FROM pay_run_results r
3568: WHERE r.element_type_id = g_paye_element_id
3569: AND r.status IN ('P', 'PA', 'O') -- add overridden for SR 4310794.996
3570: AND r.assignment_action_id = p_last_asg_action_id;
3571: --

Line 3578: r2 PAY_RUN_RESULTS_N50)

3574: -- bug 889323 ensure the last action included PAYE Details result
3575: -- bug 1236784 ignore reversal/reversed runs
3576: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3577: pact PAY_PAYROLL_ACTIONS_PK,
3578: r2 PAY_RUN_RESULTS_N50)
3579: USE_NL(assact2, pact, r2) */
3580: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3581: ||r2.source_type||
3582: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,

Line 3587: pay_run_results r2

3583: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3584: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3585: FROM pay_assignment_actions assact2,
3586: pay_payroll_actions pact,
3587: pay_run_results r2
3588: WHERE assact2.assignment_id = p_assignment_id
3589: AND r2.element_type_id+0 = g_paye_details_id
3590: AND r2.assignment_action_id = assact2.assignment_action_id
3591: AND r2.status IN ('P', 'PA')

Line 3624: r2 PAY_RUN_RESULTS_N50)

3620: cursor csr_tax_latest_paye_run(p_assignment_id NUMBER,
3621: p_asg_last_eff_date DATE) IS
3622: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3623: pact PAY_PAYROLL_ACTIONS_PK,
3624: r2 PAY_RUN_RESULTS_N50)
3625: USE_NL(assact2, pact, r2) */
3626: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3627: ||r2.source_type||
3628: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,

Line 3635: pay_run_results r2

3631: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3632: -- r2.run_result_id),16))
3633: FROM pay_assignment_actions assact2,
3634: pay_payroll_actions pact,
3635: pay_run_results r2
3636: WHERE assact2.assignment_id = p_assignment_id
3637: AND r2.element_type_id+0 = g_paye_element_id
3638: AND r2.assignment_action_id = assact2.assignment_action_id
3639: AND r2.status IN ('P', 'PA', 'O') -- add overridden for SR 4310794.996