APPS.PAY_NL_GENERAL dependencies on PAY_RUN_RESULTS

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

291: SELECT ptp.start_date
292: FROM per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa,
295: pay_run_results prr,
296: pay_element_entries_f pee
297: WHERE pee.element_entry_id=c_element_entry_id
298: and prr.run_result_id = pee.source_id
299: and paa.assignment_action_id=prr.assignment_action_id

Line 315: pay_run_results prr,

311: SELECT ptp.start_date
312: FROM per_time_periods ptp,
313: pay_payroll_actions ppa,
314: pay_assignment_actions paa,
315: pay_run_results prr,
316: pay_element_entries_f pee
317: WHERE pee.element_entry_id=c_element_entry_id
318: and prr.run_result_id = pee.source_id
319: and paa.assignment_action_id=prr.assignment_action_id

Line 335: pay_run_results prr,

331: SELECT ptp.start_date
332: FROM per_time_periods ptp,
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: pay_run_results prr,
336: pay_element_entries_f pee
337: WHERE pee.element_entry_id=c_element_entry_id
338: and prr.run_result_id = pee.source_id
339: and paa.assignment_action_id=prr.assignment_action_id

Line 501: ,pay_run_results prr

497: ,pay_input_values_f piv
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

Line 1367: pay_run_results prr,

1363: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
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

Line 1412: pay_run_results prr,

1408: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
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,

Line 1468: pay_run_results prr,

1464: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
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

Line 1500: pay_run_results prr,

1496: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
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

Line 1549: pay_run_results prr,

1545: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
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

Line 1704: pay_run_results prr,

1700: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
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,