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 1083: pay_run_results prr,

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

Line 1184: pay_run_results prr,

1180: is
1181: select
1182: fnd_number.canonical_to_number(prrv.result_value) value
1183: from pay_run_result_values prrv,
1184: pay_run_results prr,
1185: pay_payroll_actions ppa,
1186: pay_assignment_actions paa
1187: where paa.assignment_action_id = p_assignment_action_id
1188: and ppa.payroll_action_id = paa.payroll_action_id

Line 1285: pay_run_results prr,

1281: is
1282: select
1283: prrv.result_value value
1284: from pay_run_result_values prrv,
1285: pay_run_results prr,
1286: pay_payroll_actions ppa,
1287: pay_assignment_actions paa
1288: where paa.assignment_action_id = p_assignment_action_id
1289: and ppa.payroll_action_id = paa.payroll_action_id

Line 1320: p_run_result_id in pay_run_results.run_result_id%type,

1316: --
1317: -- Bug 4442482: Added new function get_result_value
1318:
1319: function get_result_value (
1320: p_run_result_id in pay_run_results.run_result_id%type,
1321: p_input_value_id in pay_input_values_f.input_value_id%type
1322: ) return varchar2 is
1323: cursor csr_result_value is
1324: select result_value