APPS.PAY_US_ACTION_ARCH dependencies on PAY_RUN_RESULTS

Line 1566: from pay_run_results prr,

1562: sum(decode(piv.name, 'Pay Value', prrv.result_value)),
1563: sum(decode(piv.name, 'Hours', prrv.result_value)),
1564: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1565: sum(decode(piv.name, 'Rate', prrv.result_value))
1566: from pay_run_results prr,
1567: pay_run_result_values prrv,
1568: pay_input_values_f piv,
1569: pay_entry_process_details pepd
1570: where piv.input_value_id = prrv.input_value_id

Line 4450: ** Get Jurisdictions from pay_run_results for all locked actions

4446:
4447: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
4448:
4449: /*****************************************************************
4450: ** Get Jurisdictions from pay_run_results for all locked actions
4451: ** actions of the U,P,V case and then populating different PLSQL
4452: ** tables for State, County, City, School Dist
4453: *****************************************************************/
4454: hr_utility.trace('c_get_rr_jd parameters are---------');

Line 4650: from pay_run_results prr

4646:
4647: cursor c_get_baladj_jd(cp_baladj_action_id number
4648: ,cp_run_effective_date in date) is
4649: select distinct prr.jurisdiction_code
4650: from pay_run_results prr
4651: where prr.assignment_action_id = cp_baladj_action_id
4652: and length(prr.jurisdiction_code) >= 8
4653: and substr(prr.jurisdiction_code,8,1) <> 'U'
4654: order by prr.jurisdiction_code;