DBA Data[Home] [Help]

APPS.HZ_ORG_INFO_VALIDATE dependencies on HZ_FINANCIAL_NUMBERS

Line 416: db_content_source_type hz_financial_numbers.content_source_type%TYPE;

412: )
413: IS
414: l_count NUMBER;
415: l_financial_report_id NUMBER;
416: db_content_source_type hz_financial_numbers.content_source_type%TYPE;
417: BEGIN
418: -- mandatory field: financial_report_id
419:
420: IF (p_create_update_flag = 'C' AND

Line 439: FROM HZ_FINANCIAL_NUMBERS

435:
436: IF (p_create_update_flag = 'U') THEN
437: SELECT financial_report_id, content_source_type
438: INTO l_financial_report_id, db_content_source_type
439: FROM HZ_FINANCIAL_NUMBERS
440: WHERE financial_number_id = p_financial_numbers_rec.financial_number_id;
441:
442: if (p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM) AND
443: (l_financial_report_id <> p_financial_numbers_rec.financial_report_id)