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 1082: from pay_run_result_values prrv,

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

Line 1183: from pay_run_result_values prrv,

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

Line 1224: l_value pay_run_result_values.result_value%type;

1220: is
1221: --
1222: l_element_type_id number;
1223: l_input_value_id number;
1224: l_value pay_run_result_values.result_value%type;
1225: --
1226: cursor csr_input_value
1227: is
1228: select pet.element_type_id,

Line 1278: l_value pay_run_result_values.result_value%type;

1274: p_input_value_id in number) return varchar2
1275: --------------------------------------------------------------------------------
1276: is
1277: --
1278: l_value pay_run_result_values.result_value%type;
1279: --
1280: cursor csr_result_value
1281: is
1282: select

Line 1284: from pay_run_result_values prrv,

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

Line 1325: from pay_run_result_values

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
1325: from pay_run_result_values
1326: where run_result_id = p_run_result_id
1327: and input_value_id = p_input_value_id ;
1328: --
1329: l_result pay_run_result_values.result_value%type ;

Line 1329: l_result pay_run_result_values.result_value%type ;

1325: from pay_run_result_values
1326: where run_result_id = p_run_result_id
1327: and input_value_id = p_input_value_id ;
1328: --
1329: l_result pay_run_result_values.result_value%type ;
1330: --
1331: begin
1332: --
1333: open csr_result_value ;