DBA Data[Home] [Help]

APPS.PAY_KW_PIFSS_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 539: FROM HR_ORGANIZATION_INFORMATION

535: And l_effective_date between effective_start_date and effective_end_date;
536:
537: CURSOR csr_soc_bal_id(l_employer_id number) IS
538: SELECT ORG_INFORMATION1
539: FROM HR_ORGANIZATION_INFORMATION
540: WHERE Organization_id = l_employer_id
541: AND org_information_context = 'KW_SI_DETAILS';
542:
543: l_ret_string varchar2(2000);