APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 198: FROM hr_organization_information_v

194: CURSOR csr_final_settlement_info
195: IS
196: --
197: SELECT NVL(org_information7,'PER_IN_TERM_TEMPLATE') template
198: FROM hr_organization_information_v
199: WHERE organization_id = p_business_group_id
200: AND org_information_context= 'PER_IN_STAT_SETUP_DF';
201: --
202: l_template VARCHAR2(50);

Line 487: FROM hr_organization_information

483: --This Cursor returns Final Settlement Report Information at Bussiness Group Level.
484: CURSOR c_final_report_info(p_bus_grp_id NUMBER)
485: IS
486: SELECT org_information6
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.

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

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