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_IN_TERM_RPRT_GEN_PKG dependencies on STANDARD

Line 491: --This Cursor returns the Last Standard Process Date for an employee number.

487: FROM hr_organization_information
488: WHERE organization_id = p_bus_grp_id
489: AND org_information_context = 'PER_IN_STAT_SETUP_DF';
490:
491: --This Cursor returns the Last Standard Process Date for an employee number.
492:
493: CURSOR c_last_std_process_date(p_employee_number VARCHAR2
494: ,p_bus_grp_id NUMBER
495: ,p_term_date DATE )

Line 497: SELECT max(last_day(pos.last_standard_process_date))

493: CURSOR c_last_std_process_date(p_employee_number VARCHAR2
494: ,p_bus_grp_id NUMBER
495: ,p_term_date DATE )
496: IS
497: SELECT max(last_day(pos.last_standard_process_date))
498: FROM per_periods_of_service pos
499: ,per_people_f ppf
500: WHERE ppf.employee_number = p_employee_number
501: AND ppf.person_id = pos.person_id

Line 507: --Last Standard Process Date.

503: AND pos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
504: AND pos.actual_termination_date = p_term_date;
505:
506: --This cursor returns the maximum run assignment action id for an employee number depending on
507: --Last Standard Process Date.
508: CURSOR c_lsp_max_asg_act_id(p_employee_number VARCHAR2
509: ,p_bus_grp_id NUMBER
510: ,p_term_date DATE
511: ,p_process_date DATE)

Line 571: --for payment details depending on last standard process date.

567: AND ppos.actual_termination_date = p_term_date;
568:
569:
570: --This Cursor returns the maximum run assignment action id for an employee number
571: --for payment details depending on last standard process date.
572:
573: CURSOR c_lsp_payment_max_asg_act_id(p_employee_number VARCHAR2
574: ,p_bus_grp_id NUMBER
575: ,p_term_date DATE

Line 1099: l_process_date per_periods_of_service.last_standard_process_date%TYPE;

1095: --
1096: --
1097: --
1098: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1099: l_process_date per_periods_of_service.last_standard_process_date%TYPE;
1100: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: --
1102: l_procedure VARCHAR2(250);
1103: l_message VARCHAR2(250);

Line 1144: --Condition to get the assignment Id depending on Last Standard process Date or as of the Latest

1140: OPEN c_last_std_process_date(p_employee_number,p_bus_grp_id,l_term_date);
1141: FETCH c_last_std_process_date into l_process_date;
1142: CLOSE c_last_std_process_date;
1143:
1144: --Condition to get the assignment Id depending on Last Standard process Date or as of the Latest
1145: --Payroll run
1146: IF l_final_report_info ='LAST_STANDARD_DATE' AND l_process_date IS NOT NULL
1147: THEN
1148:

Line 1146: IF l_final_report_info ='LAST_STANDARD_DATE' AND l_process_date IS NOT NULL

1142: CLOSE c_last_std_process_date;
1143:
1144: --Condition to get the assignment Id depending on Last Standard process Date or as of the Latest
1145: --Payroll run
1146: IF l_final_report_info ='LAST_STANDARD_DATE' AND l_process_date IS NOT NULL
1147: THEN
1148:
1149: OPEN c_lsp_max_asg_act_id(p_employee_number,p_bus_grp_id,l_term_date,l_process_date);
1150: FETCH c_lsp_max_asg_act_id into l_asg_max_run_action_id;