APPS.PAY_RETRO_PKG dependencies on PAY_RUN_RESULTS

Line 413: from pay_run_results prr2

409: --
410: cursor c_rr
411: is
412: select prr2.element_type_id, prr2.element_entry_id
413: from pay_run_results prr2
414: where prr2.source_id = p_entry_id
415: and nvl(prr2.element_entry_id,-999) = p_entry_id
416: and prr2.source_type = 'E'
417: and prr2.assignment_action_id = p_aa_id;

Line 419: l_src_et_id pay_run_results.element_type_id%type;

415: and nvl(prr2.element_entry_id,-999) = p_entry_id
416: and prr2.source_type = 'E'
417: and prr2.assignment_action_id = p_aa_id;
418: --
419: l_src_et_id pay_run_results.element_type_id%type;
420: --
421: begin
422: --
423: begin

Line 426: from pay_run_results prr2

422: --
423: begin
424: select distinct prr2.element_type_id
425: into l_src_et_id
426: from pay_run_results prr2
427: where prr2.source_id = p_entry_id
428: and nvl(prr2.element_entry_id,-999) = p_entry_id
429: and prr2.source_type = 'E'
430: and prr2.assignment_action_id = p_aa_id;

Line 1087: from pay_run_results

1083: l_source_id number;
1084: begin
1085: select source_id
1086: into l_source_id
1087: from pay_run_results
1088: where run_result_id=p_rr_id;
1089: --
1090: return l_source_id;
1091: --

Line 1101: from pay_run_results

1097: l_source_type varchar2(1);
1098: begin
1099: select source_type
1100: into l_source_type
1101: from pay_run_results
1102: where run_result_id=p_rr_id;
1103: --
1104: return l_source_type;
1105: --

Line 1245: from pay_run_results prr2

1241: --
1242: if (p_run_result_id is not null) then
1243: select source_type
1244: into l_src_type
1245: from pay_run_results prr2
1246: where prr2.run_result_id = p_run_result_id;
1247: end if;
1248: --
1249: if ((p_entry_process_path is null) and (p_source_type in ('R', 'E'))) then

Line 1365: l_entry_process_path pay_run_results.entry_process_path%type;

1361: --
1362: function get_entry_path( p_run_result_id in number)
1363: return varchar2
1364: is
1365: l_entry_process_path pay_run_results.entry_process_path%type;
1366: l_source_type pay_run_results.source_type%type;
1367: l_element_type_id pay_run_results.element_type_id%type;
1368: begin
1369: --

Line 1366: l_source_type pay_run_results.source_type%type;

1362: function get_entry_path( p_run_result_id in number)
1363: return varchar2
1364: is
1365: l_entry_process_path pay_run_results.entry_process_path%type;
1366: l_source_type pay_run_results.source_type%type;
1367: l_element_type_id pay_run_results.element_type_id%type;
1368: begin
1369: --
1370: select entry_process_path,

Line 1367: l_element_type_id pay_run_results.element_type_id%type;

1363: return varchar2
1364: is
1365: l_entry_process_path pay_run_results.entry_process_path%type;
1366: l_source_type pay_run_results.source_type%type;
1367: l_element_type_id pay_run_results.element_type_id%type;
1368: begin
1369: --
1370: select entry_process_path,
1371: source_type,

Line 1376: from pay_run_results

1372: element_type_id
1373: into l_entry_process_path,
1374: l_source_type,
1375: l_element_type_id
1376: from pay_run_results
1377: where run_result_id = p_run_result_id;
1378: --
1379: return get_entry_path(p_entry_process_path => l_entry_process_path,
1380: p_source_type => l_source_type,

Line 1547: pay_run_results prr,

1543: pay_element_entry_values_f peev,
1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,
1546: pay_input_values_f piv1,
1547: pay_run_results prr,
1548: pay_entry_process_details pepd,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa,
1551: pay_retro_components prc,