DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 2695: FROM hr_organization_information

2691: -- Cursor to get employer code
2692: CURSOR csr_get_emp_code (c_organization_id NUMBER)
2693: IS
2694: SELECT org_information1
2695: FROM hr_organization_information
2696: WHERE organization_id = c_organization_id
2697: AND org_information_context = 'PQP_GB_PENSERV_REPORTING_INFO';
2698:
2699: l_proc_name VARCHAR2(61):=

Line 2703: l_employer_code hr_organization_information.org_information1%TYPE;

2699: l_proc_name VARCHAR2(61):=
2700: g_proc_name||'employer_code';
2701:
2702: l_org_id NUMBER;
2703: l_employer_code hr_organization_information.org_information1%TYPE;
2704: l_value NUMBER;
2705: --115.85
2706: l_basic_date DATE;
2707: