DBA Data[Home] [Help]

APPS.HR_SE_VALIDATE_PKG dependencies on FF_GLOBALS_F

Line 609: SELECT nvl(global_value,0) FROM ff_globals_f,

605: OR ( nvl(fnd_date.canonical_to_date(hoi.org_information4),to_date('31/12/4712','DD/MM/YYYY')) between fnd_date.canonical_to_date(p_org_information4) AND
606: nvl(fnd_date.canonical_to_date(p_org_information5),to_date('31/12/4712','DD/MM/YYYY'))));
607:
608: CURSOR csr_global(csr_v_global VARCHAR2 )IS
609: SELECT nvl(global_value,0) FROM ff_globals_f,
610: FND_SESSIONS s
611: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
612: AND legislation_code='SE'
613: and s.effective_date --p_effective_date

Line 1482: SELECT nvl(global_value,0) FROM ff_globals_f,

1478: FROM hr_organization_information
1479: WHERE org_information_id=p_org_information_id;
1480:
1481: CURSOR csr_global(csr_v_global VARCHAR2 )IS
1482: SELECT nvl(global_value,0) FROM ff_globals_f,
1483: FND_SESSIONS s
1484: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
1485: AND legislation_code='SE'
1486: and s.effective_date --p_effective_date