DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on HR_ORGANIZATION_INFORMATION

Line 2759: FROM hr_organization_information

2755: -- Cursor to get employer code
2756: CURSOR csr_get_emp_code (c_organization_id NUMBER)
2757: IS
2758: SELECT org_information1
2759: FROM hr_organization_information
2760: WHERE organization_id = c_organization_id
2761: AND org_information_context = 'PQP_GB_PENSERV_REPORTING_INFO';
2762:
2763: l_proc_name VARCHAR2(61):=

Line 2767: l_employer_code hr_organization_information.org_information1%TYPE;

2763: l_proc_name VARCHAR2(61):=
2764: g_proc_name||'employer_code';
2765:
2766: l_org_id NUMBER;
2767: l_employer_code hr_organization_information.org_information1%TYPE;
2768: l_value NUMBER;
2769: --115.85
2770: l_basic_date DATE;
2771: