APPS.PAY_KR_REPORT_PKG dependencies on PAY_RUN_RESULTS

Line 546: pay_run_results prr,

542: select
543: nvl(sum(fnd_number.canonical_to_number(prrv.result_value) * pbf.scale),0) value
544: from pay_balance_feeds_f pbf,
545: pay_run_result_values prrv,
546: pay_run_results prr,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa
549: where paa.assignment_action_id = p_assignment_action_id
550: and ppa.payroll_action_id = paa.payroll_action_id

Line 1084: pay_run_results prr,

1080: is
1081: select
1082: fnd_date.canonical_to_date(prrv.result_value) value
1083: from pay_run_result_values prrv,
1084: pay_run_results prr,
1085: pay_payroll_actions ppa,
1086: pay_assignment_actions paa
1087: where paa.assignment_action_id = p_assignment_action_id
1088: and ppa.payroll_action_id = paa.payroll_action_id

Line 1258: pay_run_results prr,

1254: is
1255: select
1256: fnd_number.canonical_to_number(prrv.result_value) value
1257: from pay_run_result_values prrv,
1258: pay_run_results prr,
1259: pay_payroll_actions ppa,
1260: pay_assignment_actions paa
1261: where paa.assignment_action_id = p_assignment_action_id
1262: and ppa.payroll_action_id = paa.payroll_action_id

Line 1359: pay_run_results prr,

1355: is
1356: select
1357: prrv.result_value value
1358: from pay_run_result_values prrv,
1359: pay_run_results prr,
1360: pay_payroll_actions ppa,
1361: pay_assignment_actions paa
1362: where paa.assignment_action_id = p_assignment_action_id
1363: and ppa.payroll_action_id = paa.payroll_action_id

Line 1394: p_run_result_id in pay_run_results.run_result_id%type,

1390: --
1391: -- Bug 4442482: Added new function get_result_value
1392:
1393: function get_result_value (
1394: p_run_result_id in pay_run_results.run_result_id%type,
1395: p_input_value_id in pay_input_values_f.input_value_id%type
1396: ) return varchar2 is
1397: cursor csr_result_value is
1398: select result_value