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_NO_SAL_STATISTICS_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 563: pay_assignment_actions paa,

559:
560: IS
561: SELECT sum(prrv.result_value) result
562: FROM
563: pay_assignment_actions paa,
564: pay_payroll_actions ppa,
565: per_time_periods ptp,
566: pay_run_results prr,
567: pay_run_result_values prrv,

Line 593: pay_assignment_actions paa,

589: p_report_date DATE)
590: IS
591: SELECT sum(prrv.result_value) result
592: FROM
593: pay_assignment_actions paa,
594: pay_payroll_actions ppa,
595: pay_run_results prr,
596: pay_run_result_values prrv,
597: pay_element_types_f pet,

Line 722: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;

718: l_effective_date := g_effective_date;
719:
720: END IF;
721:
722: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;
723: hr_nonrun_asact.insact
724: (l_assact_id
725: ,l_asg_rec.assignment_id
726: ,p_payroll_action_id

Line 1182: pay_assignment_actions assg,

1178: pai_sal.action_information18 SSB_CODE_0040_YTD,
1179: pai_sal.action_information19 SSB_CODE_0041_YTD
1180: FROM
1181: pay_payroll_actions paa,
1182: pay_assignment_actions assg,
1183: pay_action_information pai,
1184: pay_action_information pai_sal
1185: WHERE
1186: paa.payroll_action_id = p_payroll_action_id