DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_FINANCIAL_NUMBERS

Line 1649: FROM HZ_FINANCIAL_NUMBERS

1645: x_object_version_number OUT NOCOPY NUMBER
1646: ) IS
1647: CURSOR is_fin_number_id_exist(l_fin_number_id NUMBER) IS
1648: SELECT nvl(object_version_number,1), financial_report_id
1649: FROM HZ_FINANCIAL_NUMBERS
1650: WHERE financial_number_id = l_fin_number_id
1651: AND rownum = 1;
1652:
1653: CURSOR is_fin_number_exist(l_fin_report_id NUMBER, l_fin_number_name VARCHAR2) IS

Line 1655: FROM HZ_FINANCIAL_NUMBERS

1651: AND rownum = 1;
1652:
1653: CURSOR is_fin_number_exist(l_fin_report_id NUMBER, l_fin_number_name VARCHAR2) IS
1654: SELECT nvl(object_version_number,1), financial_number_id
1655: FROM HZ_FINANCIAL_NUMBERS
1656: WHERE financial_report_id = l_fin_report_id
1657: AND financial_number_name = l_fin_number_name
1658: AND status in ('A','I')
1659: AND rownum = 1;

Line 3291: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,

3287:
3288: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3289: -- get all entities of org, for org, the possible entites are
3290: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,
3291: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,
3292: -- HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE, HZ_CONTACT_PREFERENCES
3293: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3294: p_bus_object.user_mandated_flag(i) = 'Y' AND
3295: p_bus_object.business_object_code(i) = 'ORG' AND