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 395: --This Cursor returns the Last Standard Process Date for an employee number.

391: FROM hr_organization_information
392: WHERE organization_id = p_bus_grp_id
393: AND org_information_context = 'PER_IN_STAT_SETUP_DF';
394:
395: --This Cursor returns the Last Standard Process Date for an employee number.
396:
397: CURSOR c_last_std_process_date(p_employee_number VARCHAR2
398: ,p_bus_grp_id NUMBER
399: ,p_term_date DATE )

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

397: CURSOR c_last_std_process_date(p_employee_number VARCHAR2
398: ,p_bus_grp_id NUMBER
399: ,p_term_date DATE )
400: IS
401: SELECT max(last_day(pos.last_standard_process_date))
402: FROM per_periods_of_service pos
403: ,per_people_f ppf
404: WHERE ppf.employee_number = p_employee_number
405: AND ppf.person_id = pos.person_id

Line 411: --Last Standard Process Date.

407: AND pos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
408: AND pos.actual_termination_date = p_term_date;
409:
410: --This cursor returns the maximum run assignment action id for an employee number depending on
411: --Last Standard Process Date.
412: CURSOR c_lsp_max_asg_act_id(p_employee_number VARCHAR2
413: ,p_bus_grp_id NUMBER
414: ,p_term_date DATE
415: ,p_process_date DATE)

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

471: AND ppos.actual_termination_date = p_term_date;
472:
473:
474: --This Cursor returns the maximum run assignment action id for an employee number
475: --for payment details depending on last standard process date.
476:
477: CURSOR c_lsp_payment_max_asg_act_id(p_employee_number VARCHAR2
478: ,p_bus_grp_id NUMBER
479: ,p_term_date DATE

Line 1002: l_process_date per_periods_of_service.last_standard_process_date%TYPE;

998: --
999: --
1000: --
1001: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1002: l_process_date per_periods_of_service.last_standard_process_date%TYPE;
1003: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1004: --
1005: l_procedure VARCHAR2(250);
1006: l_message VARCHAR2(250);

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

1043: OPEN c_last_std_process_date(p_employee_number,p_bus_grp_id,l_term_date);
1044: FETCH c_last_std_process_date into l_process_date;
1045: CLOSE c_last_std_process_date;
1046:
1047: --Condition to get the assignment Id depending on Last Standard process Date or as of the Latest
1048: --Payroll run
1049: IF l_final_report_info ='LAST_STANDARD_DATE' AND l_process_date IS NOT NULL
1050: THEN
1051:

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

1045: CLOSE c_last_std_process_date;
1046:
1047: --Condition to get the assignment Id depending on Last Standard process Date or as of the Latest
1048: --Payroll run
1049: IF l_final_report_info ='LAST_STANDARD_DATE' AND l_process_date IS NOT NULL
1050: THEN
1051:
1052: OPEN c_lsp_max_asg_act_id(p_employee_number,p_bus_grp_id,l_term_date,l_process_date);
1053: FETCH c_lsp_max_asg_act_id into l_asg_max_run_action_id;