APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 391: FROM hr_organization_information

387: --This Cursor returns Final Settlement Report Information at Bussiness Group Level.
388: CURSOR c_final_report_info(p_bus_grp_id NUMBER)
389: IS
390: SELECT org_information6
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.

Line 1001: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition

997: l_asg_max_run_action_id pay_assignment_actions.assignment_action_id%TYPE;-- Bug 4774108 addition
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);