APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_FINANCIAL_REPORTS

Line 1584: FROM HZ_FINANCIAL_REPORTS

1580: x_object_version_number OUT NOCOPY NUMBER
1581: ) IS
1582: CURSOR is_fin_report_id_exist(l_fin_report_id NUMBER)IS
1583: SELECT nvl(object_version_number,1), party_id
1584: FROM HZ_FINANCIAL_REPORTS
1585: WHERE financial_report_id = l_fin_report_id
1586: AND rownum = 1;
1587:
1588: CURSOR is_fin_report_exist(l_party_id NUMBER, l_type_of_fin_report VARCHAR2,

Line 1592: FROM HZ_FINANCIAL_REPORTS

1588: CURSOR is_fin_report_exist(l_party_id NUMBER, l_type_of_fin_report VARCHAR2,
1589: l_doc_reference VARCHAR2, l_date_report_issued DATE,
1590: l_issued_period VARCHAR2 )IS
1591: SELECT nvl(object_version_number,1), financial_report_id
1592: FROM HZ_FINANCIAL_REPORTS
1593: WHERE party_id = l_party_id
1594: AND type_of_financial_report = l_type_of_fin_report
1595: AND document_reference = l_doc_reference
1596: AND (trunc(date_report_issued) = trunc(l_date_report_issued) OR

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