APPS.PAY_KR_REPORT_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 545: pay_run_result_values prrv,

541: is
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

Line 1083: from pay_run_result_values prrv,

1079: cursor csr_result_value
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

Line 1182: l_value pay_run_result_values.result_value%type;

1178: l_element_type_id number;
1179: l_input_value_id number;
1180: l_element_type_id2 number;
1181: l_input_value_id2 number;
1182: l_value pay_run_result_values.result_value%type;
1183: --
1184: cursor csr_result_value
1185: is
1186:

Line 1257: from pay_run_result_values prrv,

1253: cursor csr_result_value
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

Line 1298: l_value pay_run_result_values.result_value%type;

1294: is
1295: --
1296: l_element_type_id number;
1297: l_input_value_id number;
1298: l_value pay_run_result_values.result_value%type;
1299: --
1300: cursor csr_input_value
1301: is
1302: select pet.element_type_id,

Line 1352: l_value pay_run_result_values.result_value%type;

1348: p_input_value_id in number) return varchar2
1349: --------------------------------------------------------------------------------
1350: is
1351: --
1352: l_value pay_run_result_values.result_value%type;
1353: --
1354: cursor csr_result_value
1355: is
1356: select

Line 1358: from pay_run_result_values prrv,

1354: cursor csr_result_value
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

Line 1399: from pay_run_result_values

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
1399: from pay_run_result_values
1400: where run_result_id = p_run_result_id
1401: and input_value_id = p_input_value_id ;
1402: --
1403: l_result pay_run_result_values.result_value%type ;

Line 1403: l_result pay_run_result_values.result_value%type ;

1399: from pay_run_result_values
1400: where run_result_id = p_run_result_id
1401: and input_value_id = p_input_value_id ;
1402: --
1403: l_result pay_run_result_values.result_value%type ;
1404: --
1405: begin
1406: --
1407: open csr_result_value ;