eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_RUN_RESULTS

Line 486: from pay_run_results prr,

482: l_src_et_id,
483: l_ppath,
484: l_loc_aa_id,
485: l_loc_src_aa_id
486: from pay_run_results prr,
487: pay_assignment_actions paa
488: where prr.run_result_id = l_run_result_id
489: and prr.assignment_action_id = paa.assignment_action_id;
490: --

Line 639: from pay_run_results prr,

635: l_src_et_id,
636: l_ppath,
637: l_loc_aa_id,
638: l_loc_src_aa_id
639: from pay_run_results prr,
640: pay_assignment_actions paa
641: where prr.run_result_id = l_run_result_id
642: and prr.assignment_action_id = paa.assignment_action_id;
643: --

Line 950: FROM pay_run_results pr1

946: AND EE.entry_type <> 'E'
947: )
948: )
949: AND (NOT EXISTS (SELECT null
950: FROM pay_run_results pr1
951: WHERE pr1.source_id = EE.element_entry_id
952: AND pr1.source_type = 'E'
953: AND pr1.status <> 'U'
954: )

Line 956: FROM pay_run_results pr1

952: AND pr1.source_type = 'E'
953: AND pr1.status <> 'U'
954: )
955: OR EXISTS (SELECT null
956: FROM pay_run_results pr1
957: WHERE pr1.source_id = EE.element_entry_id
958: AND pr1.source_type = 'E'
959: AND pr1.status = 'U'
960: )

Line 1180: from pay_run_results rr

1176: delete from pay_run_result_values rrv
1177: where result_value is null
1178: and run_result_id in
1179: (select rr.run_result_id
1180: from pay_run_results rr
1181: where rr.assignment_action_id = asgt_action_ids(i))
1182: and not exists
1183: (select 1
1184: from pay_input_values_f iv

Line 1197: from pay_run_results rr

1193: delete from pay_run_result_values rrv
1194: where result_value is null
1195: and run_result_id in
1196: (select rr.run_result_id
1197: from pay_run_results rr
1198: where rr.assignment_action_id = asgt_action_ids(i));
1199: --
1200: end if;
1201: --

Line 1343: type t_rr_id is table of pay_run_results.run_result_id%type

1339: is
1340: --
1341: type t_ee_id is table of pay_element_entries_f.element_entry_id%type
1342: index by binary_integer;
1343: type t_rr_id is table of pay_run_results.run_result_id%type
1344: index by binary_integer;
1345: type t_td_id is table of pay_time_definitions.time_definition_id%type
1346: index by binary_integer;
1347: type t_action is table of pay_payroll_actions.action_type%type

Line 1402: pay_run_results prr

1398: from
1399: pay_assignment_actions paa,
1400: pay_payroll_actions ppa,
1401: pay_element_types_f pet,
1402: pay_run_results prr
1403: where paa.assignment_id = p_asg_id
1404: and paa.assignment_action_id = prr.assignment_action_id
1405: and ppa.payroll_action_id = paa.payroll_action_id
1406: and ppa.action_type in ('R', 'Q', 'B', 'V', 'I')

Line 1470: update pay_run_results

1466: fetch get_td_rr
1467: bulk collect into l_rr_tab, l_td_tab, l_action limit 100;
1468: --
1469: forall i in 1..l_rr_tab.COUNT
1470: update pay_run_results
1471: set time_definition_id = l_td_tab(i)
1472: where run_result_id = l_rr_tab(i);
1473:
1474: forall i in 1..l_rr_tab.COUNT

Line 1475: update pay_run_results prr

1471: set time_definition_id = l_td_tab(i)
1472: where run_result_id = l_rr_tab(i);
1473:
1474: forall i in 1..l_rr_tab.COUNT
1475: update pay_run_results prr
1476: set prr.start_date = (select pee.date_earned
1477: from pay_element_entries_f pee
1478: where pee.element_entry_id = prr.source_id
1479: ),

Line 1493: update pay_run_results prr

1489: and prr.start_date is null
1490: and l_action(i) <> 'V';
1491: --
1492: forall i in 1..l_rr_tab.COUNT
1493: update pay_run_results prr
1494: set prr.start_date = (select prr.start_date
1495: from pay_run_results prr2
1496: where prr2.run_result_id = prr.source_id
1497: ),

Line 1495: from pay_run_results prr2

1491: --
1492: forall i in 1..l_rr_tab.COUNT
1493: update pay_run_results prr
1494: set prr.start_date = (select prr.start_date
1495: from pay_run_results prr2
1496: where prr2.run_result_id = prr.source_id
1497: ),
1498: prr.end_date = (select prr.end_date
1499: from pay_run_results prr2

Line 1499: from pay_run_results prr2

1495: from pay_run_results prr2
1496: where prr2.run_result_id = prr.source_id
1497: ),
1498: prr.end_date = (select prr.end_date
1499: from pay_run_results prr2
1500: where prr2.run_result_id = prr.source_id
1501: )
1502: where prr.run_result_id = l_rr_tab(i)
1503: and exists (select ''

Line 1504: from pay_run_results prr2

1500: where prr2.run_result_id = prr.source_id
1501: )
1502: where prr.run_result_id = l_rr_tab(i)
1503: and exists (select ''
1504: from pay_run_results prr2
1505: where prr2.run_result_id = prr.source_id
1506: and prr2.start_date is not null)
1507: and prr.start_date is null
1508: and l_action(i) = 'V';

Line 1550: update pay_run_results

1546: end if;
1547: --
1548: --
1549: forall i in 1..l_ee_tab.COUNT
1550: update pay_run_results
1551: set start_date = l_std_tab(i),
1552: end_date = l_end_tab(i),
1553: time_definition_id = l_td_tab(i)
1554: where source_id = l_ee_tab(i)

Line 1559: update pay_run_results prr

1555: and source_type in ('E', 'I');
1556: --
1557: --
1558: forall i in 1..l_ee_tab.COUNT
1559: update pay_run_results prr
1560: set prr.start_date = l_std_tab(i),
1561: prr.end_date = l_end_tab(i),
1562: prr.time_definition_id = l_td_tab(i)
1563: where prr.source_id in (select prr1.run_result_id

Line 1564: from pay_run_results prr1

1560: set prr.start_date = l_std_tab(i),
1561: prr.end_date = l_end_tab(i),
1562: prr.time_definition_id = l_td_tab(i)
1563: where prr.source_id in (select prr1.run_result_id
1564: from pay_run_results prr1
1565: where prr1.source_id = l_ee_tab(i)
1566: and prr1.source_type in ('E', 'I')
1567: )
1568: and prr.source_type in ('R', 'V');