APPS.PAY_US_ACTION_ARCH dependencies on PAY_RUN_RESULTS

Line 1901: from pay_run_results prr,

1897: sum(decode(piv.name, 'Pay Value', prrv.result_value)),
1898: sum(decode(piv.name, 'Hours', prrv.result_value)),
1899: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1900: sum(decode(piv.name, 'Rate', prrv.result_value))
1901: from pay_run_results prr,
1902: pay_run_result_values prrv,
1903: pay_input_values_f piv,
1904: pay_entry_process_details pepd
1905: where piv.input_value_id = prrv.input_value_id

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

5392:
5393: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
5394:
5395: /*****************************************************************
5396: ** Get Jurisdictions from pay_run_results for all locked actions
5397: ** actions of the U,P,V case and then populating different PLSQL
5398: ** tables for State, County, City, School Dist
5399: *****************************************************************/
5400: hr_utility.trace('c_get_rr_jd parameters are---------');

Line 5622: from pay_run_results prr

5618:
5619: cursor c_get_baladj_jd(cp_baladj_action_id number
5620: ,cp_run_effective_date in date) is
5621: select distinct prr.jurisdiction_code
5622: from pay_run_results prr
5623: where prr.assignment_action_id = cp_baladj_action_id
5624: and length(prr.jurisdiction_code) >= 8
5625: and substr(prr.jurisdiction_code,8,1) <> 'U'
5626: order by prr.jurisdiction_code;

Line 6255: pay_run_results prr_att,

6251: ,pet.element_type_id
6252: from pay_element_entry_values_f peev,
6253: pay_input_values_f piv_att,
6254: pay_element_entries_f peef,
6255: pay_run_results prr_att,
6256: pay_run_results prr_pay,
6257: pay_payroll_actions ppa,
6258: pay_assignment_actions paa,
6259: pay_action_interlocks pai,

Line 6256: pay_run_results prr_pay,

6252: from pay_element_entry_values_f peev,
6253: pay_input_values_f piv_att,
6254: pay_element_entries_f peef,
6255: pay_run_results prr_att,
6256: pay_run_results prr_pay,
6257: pay_payroll_actions ppa,
6258: pay_assignment_actions paa,
6259: pay_action_interlocks pai,
6260: pay_pre_payments ppp,

Line 6339: pay_run_results prr_att,

6335: from pay_element_entry_values_f peev,
6336: pay_element_entry_values_f peev_pay,
6337: pay_input_values_f piv_att,
6338: pay_element_entries_f peef,
6339: pay_run_results prr_att,
6340: pay_run_results prr_pay,
6341: pay_payroll_actions ppa,
6342: pay_assignment_actions paa,
6343: pay_action_interlocks pai,

Line 6340: pay_run_results prr_pay,

6336: pay_element_entry_values_f peev_pay,
6337: pay_input_values_f piv_att,
6338: pay_element_entries_f peef,
6339: pay_run_results prr_att,
6340: pay_run_results prr_pay,
6341: pay_payroll_actions ppa,
6342: pay_assignment_actions paa,
6343: pay_action_interlocks pai,
6344: pay_pre_payments ppp,

Line 6403: from pay_run_results prr,

6399: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
6400:
6401: cursor jur ( ass_act_id number, ele_type_id number, date_ear date ) IS
6402: select prrv.result_value
6403: from pay_run_results prr,
6404: pay_run_result_values prrv,
6405: pay_input_values_f piv,
6406: pay_element_types_f pet,
6407: pay_element_types_f pet1

Line 6447: pay_run_results prr_att,

6443: ,nvl(element_information4,-1)
6444: from pay_element_entry_values_f peev,
6445: pay_input_values_f piv_att,
6446: pay_element_entries_f peef,
6447: pay_run_results prr_att,
6448: pay_payroll_actions ppa,
6449: pay_assignment_actions paa,
6450: pay_action_interlocks pai,
6451: pay_pre_payments ppp,