APPS.PAY_NL_GENERAL dependencies on PAY_RUN_RESULT_VALUES

Line 198: select prrv.result_value from pay_run_result_values prrv,pay_run_results prr

194:
195: cursor csr_get_run_result_value(p_assignment_action_id number,
196: p_element_type_id number,
197: p_input_value_id number,p_run_result_id number)is
198: select prrv.result_value from pay_run_result_values prrv,pay_run_results prr
199: where prr.assignment_action_id=p_assignment_action_id
200: and prr.element_type_id=p_element_type_id
201: and prr.run_result_id=p_run_result_id
202: and prrv.run_result_id=prr.run_result_id

Line 205: l_result_value pay_run_result_values.result_value%TYPE;

201: and prr.run_result_id=p_run_result_id
202: and prrv.run_result_id=prr.run_result_id
203: and prrv.input_value_id=p_input_value_id;
204:
205: l_result_value pay_run_result_values.result_value%TYPE;
206:
207: begin
208:
209: OPEN csr_get_run_result_value(p_assignment_action_id,p_element_type_id,p_input_value_id,p_run_result_id);

Line 241: select fnd_number.canonical_to_number(prrv.result_value) from pay_run_result_values prrv,pay_run_results prr

237:
238: cursor csr_get_run_result_value(p_assignment_action_id number,
239: p_element_type_id number,
240: p_input_value_id number)is
241: select fnd_number.canonical_to_number(prrv.result_value) from pay_run_result_values prrv,pay_run_results prr
242: where prr.assignment_action_id=p_assignment_action_id
243: and prr.element_type_id=p_element_type_id
244: and prrv.run_result_id=prr.run_result_id
245: and prrv.input_value_id=p_input_value_id;

Line 460: from pay_run_result_values rrv

456: v_cur_iv_id cur_iv_id%ROWTYPE;
457:
458: CURSOR cur_iv_rrv(lp_input_value_id number,lp_run_result_id in number) IS
459: SELECT rrv.result_value
460: from pay_run_result_values rrv
461: where rrv.input_value_id=lp_input_value_id
462: and rrv.run_result_id=p_run_result_id;
463: v_cur_iv_rrv cur_iv_rrv%ROWTYPE;
464:

Line 502: ,pay_run_result_values prrv

498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr
502: ,pay_run_result_values prrv
503: ,pay_run_result_values prrv1
504: WHERE pbf.balance_type_id = pbt.balance_type_id
505: AND pbt.balance_type_id = lp_balance_type_id
506: AND piv.input_value_id = pbf.input_value_id

Line 503: ,pay_run_result_values prrv1

499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr
502: ,pay_run_result_values prrv
503: ,pay_run_result_values prrv1
504: WHERE pbf.balance_type_id = pbt.balance_type_id
505: AND pbt.balance_type_id = lp_balance_type_id
506: AND piv.input_value_id = pbf.input_value_id
507: AND (piv.name ='Pay Value'

Line 1368: pay_run_result_values prv,

1364: from
1365: pay_payroll_actions ppa,
1366: pay_assignment_actions paa,
1367: pay_run_results prr,
1368: pay_run_result_values prv,
1369: pay_element_types_f pet,
1370: pay_element_classifications pec,
1371: pay_input_values_f piv
1372: where

Line 1413: pay_run_result_values prv,

1409: from
1410: pay_payroll_actions ppa,
1411: pay_assignment_actions paa,
1412: pay_run_results prr,
1413: pay_run_result_values prv,
1414: pay_element_types_f pet,
1415: pay_element_classifications pec,
1416: pay_sub_classification_rules_f pecs,
1417: pay_input_values_f piv

Line 1469: pay_run_result_values prv,

1465: from
1466: pay_payroll_actions ppa,
1467: pay_assignment_actions paa,
1468: pay_run_results prr,
1469: pay_run_result_values prv,
1470: pay_run_result_values prv1,
1471: pay_action_contexts pac,
1472: pay_input_values_f piv
1473: where

Line 1470: pay_run_result_values prv1,

1466: pay_payroll_actions ppa,
1467: pay_assignment_actions paa,
1468: pay_run_results prr,
1469: pay_run_result_values prv,
1470: pay_run_result_values prv1,
1471: pay_action_contexts pac,
1472: pay_input_values_f piv
1473: where
1474: paa.payroll_action_id=ppa.payroll_action_id

Line 1501: pay_run_result_values prv,

1497: from
1498: pay_payroll_actions ppa,
1499: pay_assignment_actions paa,
1500: pay_run_results prr,
1501: pay_run_result_values prv,
1502: pay_input_values_f piv
1503: Where
1504: paa.payroll_action_id=ppa.payroll_action_id
1505: and paa.SOURCE_ACTION_ID is not null

Line 1550: pay_run_result_values prv,

1546: from
1547: pay_payroll_actions ppa,
1548: pay_assignment_actions paa,
1549: pay_run_results prr,
1550: pay_run_result_values prv,
1551: pay_element_types_f pet,
1552: pay_element_classifications pec,
1553: pay_input_values_f piv
1554: where

Line 1705: pay_run_result_values prv,

1701: from
1702: pay_payroll_actions ppa,
1703: pay_assignment_actions paa,
1704: pay_run_results prr,
1705: pay_run_result_values prv,
1706: pay_element_types_f pet,
1707: pay_element_classifications pec,
1708: pay_sub_classification_rules_f pecs,
1709: pay_input_values_f piv