APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_RUN_RESULTS

Line 81: PAY_RUN_RESULTS in updates after balances have

77: get_scon_bal to include 'Employer' balances.
78: Setting 'Total' to 'Employer' balance for
79: category 'S' and all other balances to 0.
80: amyers 110.11 06-NOV-1998 Fixed bug 715534. Added status checks to table
81: PAY_RUN_RESULTS in updates after balances have
82: been fetched.
83: amyers 110.12 23-FEB-1999 Fixed bug 818887. Aggregate rows by scon and
84: category; takes care of situation where more
85: then one can be returned.

Line 474: ,pay_run_results RR

470: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO
471: from pay_balance_feeds_f FEED
472: ,pay_balance_types BAL
473: ,pay_run_result_values TARGET
474: ,pay_run_results RR
475: ,pay_element_entry_values_f EV_SCON
476: ,pay_element_entries_f E_NI
477: ,pay_element_links_f EL_NI
478: ,pay_payroll_actions PACT

Line 776: select 10 * pay_run_results_s.nextval

772: pay_element_types_f where element_name = 'PAYE Details'
773: and l_end_year between
774: effective_start_date and effective_end_date;
775: --
776: select 10 * pay_run_results_s.nextval
777: into l_max_run_result_id
778: from dual;
779: --
780: select element_type_id into l_ni_id from

Line 1657: (select RUN_RESULT_ID from pay_run_results r

1653: /* most people will have had paye calculated on the last run - pick these up */
1654: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',30);
1655: hr_utility.trace( 'see if tax was calculated on the last run of the year' );
1656: update pay_gb_year_end_assignments ye_asg set ( TAX_RUN_RESULT_ID ) =
1657: (select RUN_RESULT_ID from pay_run_results r
1658: where r.element_type_id = l_paye_details_id
1659: and r.status in ('P', 'PA')
1660: and r.assignment_action_id = ye_asg.LAST_ASG_ACTION_ID )
1661: where ye_asg.request_id = p_request_id;

Line 1670: pay_run_results r

1666: hr_utility.trace( 'find the latest tax calculation in the year' );
1667: update pay_gb_year_end_assignments ye_asg set ( TAX_RUN_RESULT_ID ) =
1668: (select r.RUN_RESULT_ID
1669: from pay_assignment_actions assact,
1670: pay_run_results r
1671: where r.element_type_id+0 = l_paye_details_id + decode(assact.assignment_id,null,0,0)
1672: and r.assignment_action_id = assact.assignment_action_id
1673: and r.status in ('P', 'PA')
1674: and assact.assignment_id = ye_asg.assignment_id