APPS.PAY_RETRO_PKG dependencies on PAY_RUN_RESULTS

Line 429: from pay_run_results prr2

425: --
426: cursor c_rr
427: is
428: select prr2.element_type_id, prr2.element_entry_id
429: from pay_run_results prr2
430: where prr2.source_id = p_entry_id
431: and nvl(prr2.element_entry_id,-999) = p_entry_id
432: and prr2.source_type = 'E'
433: and prr2.assignment_action_id = p_aa_id;

Line 435: l_src_et_id pay_run_results.element_type_id%type;

431: and nvl(prr2.element_entry_id,-999) = p_entry_id
432: and prr2.source_type = 'E'
433: and prr2.assignment_action_id = p_aa_id;
434: --
435: l_src_et_id pay_run_results.element_type_id%type;
436: --
437: begin
438: --
439: begin

Line 442: from pay_run_results prr2

438: --
439: begin
440: select distinct prr2.element_type_id
441: into l_src_et_id
442: from pay_run_results prr2
443: where prr2.source_id = p_entry_id
444: and nvl(prr2.element_entry_id,-999) = p_entry_id
445: and prr2.source_type = 'E'
446: and prr2.assignment_action_id = p_aa_id;

Line 1118: from pay_run_results

1114: l_source_id number;
1115: begin
1116: select source_id
1117: into l_source_id
1118: from pay_run_results
1119: where run_result_id=p_rr_id;
1120: --
1121: return l_source_id;
1122: --

Line 1132: from pay_run_results

1128: l_source_type varchar2(1);
1129: begin
1130: select source_type
1131: into l_source_type
1132: from pay_run_results
1133: where run_result_id=p_rr_id;
1134: --
1135: return l_source_type;
1136: --

Line 1276: from pay_run_results prr2

1272: --
1273: if (p_run_result_id is not null) then
1274: select source_type
1275: into l_src_type
1276: from pay_run_results prr2
1277: where prr2.run_result_id = p_run_result_id;
1278: end if;
1279: --
1280: if ((p_entry_process_path is null) and (p_source_type in ('R', 'E'))) then

Line 1396: l_entry_process_path pay_run_results.entry_process_path%type;

1392: --
1393: function get_entry_path( p_run_result_id in number)
1394: return varchar2
1395: is
1396: l_entry_process_path pay_run_results.entry_process_path%type;
1397: l_source_type pay_run_results.source_type%type;
1398: l_element_type_id pay_run_results.element_type_id%type;
1399: begin
1400: --

Line 1397: l_source_type pay_run_results.source_type%type;

1393: function get_entry_path( p_run_result_id in number)
1394: return varchar2
1395: is
1396: l_entry_process_path pay_run_results.entry_process_path%type;
1397: l_source_type pay_run_results.source_type%type;
1398: l_element_type_id pay_run_results.element_type_id%type;
1399: begin
1400: --
1401: select entry_process_path,

Line 1398: l_element_type_id pay_run_results.element_type_id%type;

1394: return varchar2
1395: is
1396: l_entry_process_path pay_run_results.entry_process_path%type;
1397: l_source_type pay_run_results.source_type%type;
1398: l_element_type_id pay_run_results.element_type_id%type;
1399: begin
1400: --
1401: select entry_process_path,
1402: source_type,

Line 1407: from pay_run_results

1403: element_type_id
1404: into l_entry_process_path,
1405: l_source_type,
1406: l_element_type_id
1407: from pay_run_results
1408: where run_result_id = p_run_result_id;
1409: --
1410: return get_entry_path(p_entry_process_path => l_entry_process_path,
1411: p_source_type => l_source_type,

Line 1580: pay_run_results prr,

1576: pay_element_entry_values_f peev,
1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,
1579: pay_input_values_f piv1,
1580: pay_run_results prr,
1581: pay_entry_process_details pepd,
1582: pay_assignment_actions paa,
1583: pay_payroll_actions ppa,
1584: pay_retro_components prc,