APPS.FV_UTILITY dependencies on DUAL

Line 157: FROM dual;

153: l_module_name := g_module_name || 'TIME_STAMP';
154:
155: SELECT to_char(SYSDATE, 'MM/DD/YYYY HH:MM:SS')
156: INTO l_time
157: FROM dual;
158:
159: RETURN (l_time);
160: EXCEPTION
161: WHEN OTHERS THEN

Line 770: p_individual_1099 IN VARCHAR2,

766: (
767: p_vendor_type_lookup_code IN VARCHAR2,
768: p_org_type_lookup_code IN VARCHAR2,
769: p_num_1099 IN VARCHAR2,
770: p_individual_1099 IN VARCHAR2,
771: p_employee_id IN NUMBER
772: )
773: RETURN VARCHAR2
774: IS

Line 789: l_tin := NVL(p_num_1099, p_individual_1099);

785: WHERE person_id = p_employee_id
786: AND ROWNUM < 2;
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: l_tin := NVL(p_num_1099, p_individual_1099);
790: END;
791: ELSIF(p_vendor_type_lookup_code = 'CONTRACTOR') THEN
792: IF (p_org_type_lookup_code IN ('INDIVIDUAL', 'FOREIGN INDIVIDUAL', 'PARTNERSHIP', 'FOREIGN PARTNERSHIP')) THEN
793: l_tin := p_individual_1099;

Line 792: IF (p_org_type_lookup_code IN ('INDIVIDUAL', 'FOREIGN INDIVIDUAL', 'PARTNERSHIP', 'FOREIGN PARTNERSHIP')) THEN

788: WHEN NO_DATA_FOUND THEN
789: l_tin := NVL(p_num_1099, p_individual_1099);
790: END;
791: ELSIF(p_vendor_type_lookup_code = 'CONTRACTOR') THEN
792: IF (p_org_type_lookup_code IN ('INDIVIDUAL', 'FOREIGN INDIVIDUAL', 'PARTNERSHIP', 'FOREIGN PARTNERSHIP')) THEN
793: l_tin := p_individual_1099;
794: ELSE
795: l_tin := p_num_1099;
796: END IF;

Line 793: l_tin := p_individual_1099;

789: l_tin := NVL(p_num_1099, p_individual_1099);
790: END;
791: ELSIF(p_vendor_type_lookup_code = 'CONTRACTOR') THEN
792: IF (p_org_type_lookup_code IN ('INDIVIDUAL', 'FOREIGN INDIVIDUAL', 'PARTNERSHIP', 'FOREIGN PARTNERSHIP')) THEN
793: l_tin := p_individual_1099;
794: ELSE
795: l_tin := p_num_1099;
796: END IF;
797: ELSE

Line 798: l_tin := NVL(p_num_1099, p_individual_1099);

794: ELSE
795: l_tin := p_num_1099;
796: END IF;
797: ELSE
798: l_tin := NVL(p_num_1099, p_individual_1099);
799: END IF;
800: RETURN l_tin;
801: EXCEPTION
802: WHEN OTHERS THEN