DBA Data[Home] [Help]

APPS.PAY_NO_ABS_VALIDATION dependencies on FND_NUMBER

Line 566: SELECT fnd_number.canonical_to_number(global_value)

562: WHERE pceif.contact_relationship_id = p_con_relationship_id
563: AND pceif.information_type = 'NO_CMS_DIS_DATE';
564:
565: CURSOR csr_get_glb_value(p_global_name VARCHAR2, p_effective_date DATE) IS
566: SELECT fnd_number.canonical_to_number(global_value)
567: FROM ff_globals_f
568: WHERE global_name = p_global_name
569: AND legislation_code = 'NO'
570: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 747: SELECT fnd_number.canonical_to_number(global_value)

743: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
744:
745: -- Cursor to fetch global values
746: CURSOR csr_get_glb_value(p_global_name VARCHAR2, p_effective_date DATE) IS
747: SELECT fnd_number.canonical_to_number(global_value)
748: FROM ff_globals_f
749: WHERE global_name = p_global_name
750: AND legislation_code = 'NO'
751: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;