APPS.JL_INTERFACE_VAL dependencies on DUAL

Line 1688: ('INDIVIDUAL','LEGAL_ENTITY','FOREIGN_ENTITY')) OR

1684:
1685: -- Checking for Natural people, Foreign and Legal Entity
1686:
1687: IF (p_glob_attr_set1.global_attribute10 NOT IN
1688: ('INDIVIDUAL','LEGAL_ENTITY','FOREIGN_ENTITY')) OR
1689: (p_glob_attr_set1.global_attribute10 IS NULL) THEN
1690:
1691: -- Return the record status and the error message code
1692: -- (j2 -Invalid Value in Global Attribute10)

Line 1852: FROM dual

1848:
1849: BEGIN
1850: SELECT 'x'
1851: INTO l_lookup_code
1852: FROM dual
1853: WHERE exists (select lookup_code
1854: from fnd_lookups
1855: where lookup_type = 'JLAR_TAXID_TYPE'
1856: and lookup_code = p_glob_attr_set1.global_attribute10);

Line 2811: from dual;

2807:
2808: BEGIN
2809: select to_number(l_inscription_type)
2810: into l_num_check
2811: from dual;
2812: EXCEPTION WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2813: l_error_code := l_error_code||'n3,';
2814: END;
2815: IF l_error_code is NULL THEN

Line 2821: from dual;

2817: l_inscription_type = '2' THEN
2818: BEGIN
2819: select to_number(l_inscription_number)
2820: into l_num_check
2821: from dual;
2822: EXCEPTION WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2823: l_error_code := l_error_code||'n4,';
2824: END;
2825:

Line 2829: from dual;

2825:
2826: BEGIN
2827: select to_number(l_inscription_branch)
2828: into l_num_check
2829: from dual;
2830: EXCEPTION WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2831: l_error_code := l_error_code ||'n5,';
2832: END;
2833:

Line 2837: from dual;

2833:
2834: BEGIN
2835: select to_number(l_inscription_digit)
2836: into l_num_check
2837: from dual;
2838: EXCEPTION WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2839: l_error_code := l_error_code ||'n6,';
2840: END;
2841: END IF;