APPS.AMW_PROCESS_CERT_SCOPE_PVT dependencies on AMW_AUDIT_UNITS_V

Line 97: FROM amw_audit_units_v audit_v;

93: CURSOR c_audit_unit IS
94: SELECT audit_v.company_code,audit_v.subsidiary_valueset,
95: audit_v.lob_code,audit_v.lob_valueset,
96: audit_v.organization_id
97: FROM amw_audit_units_v audit_v;
98:
99: CURSOR c_org_process IS
100: SELECT org_v.child_process_id as top_process_id,
101: org_v.child_organization_id as organization_id,

Line 105: amw_audit_units_v audit_v

101: org_v.child_organization_id as organization_id,
102: audit_v.company_code,audit_v.subsidiary_valueset,
103: audit_v.lob_code,audit_v.lob_valueset
104: FROM AMW_CURR_APP_HIERARCHY_ORG_V org_v,
105: amw_audit_units_v audit_v
106: where org_v.parent_process_id = -2
107: and audit_v.organization_id = org_v.child_organization_id;
108: l_api_name VARCHAR2(150) := 'Insert_Audit_Units';
109: BEGIN

Line 356: FROM amw_audit_units_v audit_v

352: CURSOR c_audit_unit(p_org_id NUMBER) IS
353: SELECT audit_v.company_code,audit_v.subsidiary_valueset,
354: audit_v.lob_code,audit_v.lob_valueset,
355: audit_v.organization_id
356: FROM amw_audit_units_v audit_v
357: WHERE organization_id = p_org_id;
358:
359: l_api_name VARCHAR2(150) := 'Insert_Specific_Audit_Units';
360: l_api_version_number CONSTANT NUMBER := 1.0;

Line 373: amw_audit_units_v audit_v

369: audit_v.subsidiary_valueset,
370: audit_v.lob_code,
371: audit_v.lob_valueset
372: FROM AMW_CURR_APP_HIERARCHY_ORG_V org_v,
373: amw_audit_units_v audit_v
374: WHERE org_v.parent_process_id = -2
375: AND audit_v.organization_id = org_v.child_organization_id
376: AND audit_v.organization_id =';
377:

Line 383: l_company_code amw_audit_units_v.company_code%TYPE;

379: l_final_query VARCHAR2(32767);
380:
381: l_process_id NUMBER;
382: l_organization_id NUMBER;
383: l_company_code amw_audit_units_v.company_code%TYPE;
384: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
385: l_lob_code amw_audit_units_v.lob_code%TYPE;
386: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
387:

Line 384: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;

380:
381: l_process_id NUMBER;
382: l_organization_id NUMBER;
383: l_company_code amw_audit_units_v.company_code%TYPE;
384: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
385: l_lob_code amw_audit_units_v.lob_code%TYPE;
386: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
387:
388: BEGIN

Line 385: l_lob_code amw_audit_units_v.lob_code%TYPE;

381: l_process_id NUMBER;
382: l_organization_id NUMBER;
383: l_company_code amw_audit_units_v.company_code%TYPE;
384: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
385: l_lob_code amw_audit_units_v.lob_code%TYPE;
386: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
387:
388: BEGIN
389:

Line 386: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;

382: l_organization_id NUMBER;
383: l_company_code amw_audit_units_v.company_code%TYPE;
384: l_subsidiary_valueset amw_audit_units_v.subsidiary_valueset%TYPE;
385: l_lob_code amw_audit_units_v.lob_code%TYPE;
386: l_lob_valueset amw_audit_units_v.lob_valueset%TYPE;
387:
388: BEGIN
389:
390: SAVEPOINT INSERT_SPEC_AUDIT_UNITS_PVT;