DBA Data[Home] [Help]

APPS.HR_SE_VALIDATE_PKG dependencies on FF_GLOBALS_F

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

600: 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
601: nvl(fnd_date.canonical_to_date(p_org_information5),to_date('31/12/4712','DD/MM/YYYY'))));
602:
603: CURSOR csr_global(csr_v_global VARCHAR2 )IS
604: SELECT nvl(global_value,0) FROM ff_globals_f,
605: FND_SESSIONS s
606: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
607: AND legislation_code='SE'
608: and s.effective_date --p_effective_date

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

1473: FROM hr_organization_information
1474: WHERE org_information_id=p_org_information_id;
1475:
1476: CURSOR csr_global(csr_v_global VARCHAR2 )IS
1477: SELECT nvl(global_value,0) FROM ff_globals_f,
1478: FND_SESSIONS s
1479: WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
1480: AND legislation_code='SE'
1481: and s.effective_date --p_effective_date