APPS.FV_UTILITY dependencies on DUAL

Line 156: FROM dual;

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

Line 769: p_individual_1099 IN VARCHAR2,

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

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

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

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

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

Line 792: l_tin := p_individual_1099;

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

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

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