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 335: pay_run_results prr

331: -- SCON while the Run Result still holds a valid SCON.
332: --
333: select prrv.result_value
334: from pay_run_result_values prrv,
335: pay_run_results prr
336: where prr.source_id = c_element_entry_id
337: and prr.element_type_id = g_ni_id
338: and prr.assignment_action_id = c_assignment_action_id
339: and prrv.run_result_id = prr.run_result_id

Line 3231: l_tax_run_result_id pay_run_results.run_result_id%TYPE;

3227: l_dummy NUMBER(1);
3228: l_index1 binary_integer;
3229: l_index2 binary_integer;
3230: --
3231: l_tax_run_result_id pay_run_results.run_result_id%TYPE;
3232: l_tax_paye_run_result_id pay_run_results.run_result_id%TYPE;
3233: --
3234: l_tax_code VARCHAR2(10);
3235: l_w1_m1_indicator VARCHAR2(1);

Line 3232: l_tax_paye_run_result_id pay_run_results.run_result_id%TYPE;

3228: l_index1 binary_integer;
3229: l_index2 binary_integer;
3230: --
3231: l_tax_run_result_id pay_run_results.run_result_id%TYPE;
3232: l_tax_paye_run_result_id pay_run_results.run_result_id%TYPE;
3233: --
3234: l_tax_code VARCHAR2(10);
3235: l_w1_m1_indicator VARCHAR2(1);
3236: l_previous_taxable_pay NUMBER(15);

Line 3474: pay_run_results prr

3470: 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))
3471: FROM pay_payroll_Actions pact,
3472: pay_assignment_actions act,
3473: per_all_assignments_f paf,
3474: pay_run_results prr
3475: WHERE pact.payroll_Action_id = act.payroll_Action_id
3476: AND pact.effective_date BETWEEN g_start_year and g_end_year
3477: --AND act.action_status = 'C'
3478: AND act.action_status in ('C','S') --Modified for the bug 10066755

Line 3586: ,pay_run_results rr

3582: rebate_emp
3583: FROM pay_balance_feeds_f feed
3584: ,pay_balance_types bal
3585: ,pay_run_result_values target
3586: ,pay_run_results rr
3587: ,pay_element_entry_values_f ev_scon
3588: ,pay_element_entry_values_f ev_cat
3589: ,pay_element_entries_f e_ni
3590: ,pay_element_links_f el_ni

Line 3699: FROM pay_run_results r

3695: --
3696: /* EOY 2012/2013 end block */
3697: cursor csr_tax_last_run(p_last_asg_action_id NUMBER) IS
3698: 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
3699: FROM pay_run_results r
3700: WHERE r.element_type_id = g_paye_details_id
3701: AND r.status IN ('P', 'PA')
3702: AND r.assignment_action_id = p_last_asg_action_id;
3703: --

Line 3706: FROM pay_run_results r

3702: AND r.assignment_action_id = p_last_asg_action_id;
3703: --
3704: cursor csr_tax_last_paye_run(p_last_asg_action_id NUMBER) IS
3705: 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
3706: FROM pay_run_results r
3707: WHERE r.element_type_id = g_paye_element_id
3708: AND r.status IN ('P', 'PA', 'O') -- add overridden for SR 4310794.996
3709: AND r.assignment_action_id = p_last_asg_action_id;
3710: --

Line 3717: r2 PAY_RUN_RESULTS_N50)

3713: -- bug 889323 ensure the last action included PAYE Details result
3714: -- bug 1236784 ignore reversal/reversed runs
3715: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3716: pact PAY_PAYROLL_ACTIONS_PK,
3717: r2 PAY_RUN_RESULTS_N50)
3718: USE_NL(assact2, pact, r2) */
3719: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3720: ||r2.source_type||
3721: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,

Line 3726: pay_run_results r2

3722: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3723: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3724: FROM pay_assignment_actions assact2,
3725: pay_payroll_actions pact,
3726: pay_run_results r2
3727: WHERE assact2.assignment_id = p_assignment_id
3728: AND r2.element_type_id+0 = g_paye_details_id
3729: AND r2.assignment_action_id = assact2.assignment_action_id
3730: AND r2.status IN ('P', 'PA')

Line 3764: r2 PAY_RUN_RESULTS_N50)

3760: cursor csr_tax_latest_paye_run(p_assignment_id NUMBER,
3761: p_asg_last_eff_date DATE) IS
3762: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3763: pact PAY_PAYROLL_ACTIONS_PK,
3764: r2 PAY_RUN_RESULTS_N50)
3765: USE_NL(assact2, pact, r2) */
3766: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3767: ||r2.source_type||
3768: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,

Line 3775: pay_run_results r2

3771: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3772: -- r2.run_result_id),16))
3773: FROM pay_assignment_actions assact2,
3774: pay_payroll_actions pact,
3775: pay_run_results r2
3776: WHERE assact2.assignment_id = p_assignment_id
3777: AND r2.element_type_id+0 = g_paye_element_id
3778: AND r2.assignment_action_id = assact2.assignment_action_id
3779: AND r2.status IN ('P', 'PA', 'O') -- add overridden for SR 4310794.996