APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_AUDIT_UNITS_V

Line 3673: FROM AMW_PROCESS_ORGANIZATION PO ,amw_audit_units_v aauv

3669: SELECT PO.ORGANIZATION_ID,
3670: PO.PROCESS_ID,
3671: PO.REVISION_NUMBER,
3672: PO.PROCESS_ORG_REV_ID
3673: FROM AMW_PROCESS_ORGANIZATION PO ,amw_audit_units_v aauv
3674: WHERE /*02.13.07 npanandi: bug 5043879 fix for
3675: including only those orgs that are active */
3676: po.organization_id = aauv.organization_id
3677: and

Line 3745: AMW_PROCESS_ORGANIZATION orgproc, amw_audit_units_v aauv

3741: CURSOR c_child_processes(p_proc_id NUMBER, p_org_id NUMBER) IS
3742: SELECT distinct temp.child_process_id, temp.organization_id, orgproc.revision_number,
3743: orgproc.process_org_rev_id
3744: FROM AMW_FIN_PROCESS_FLAT temp,
3745: AMW_PROCESS_ORGANIZATION orgproc, amw_audit_units_v aauv
3746: WHERE /*02.13.07 npanandi: bug 5043879 fix for
3747: including only those orgs that are active */
3748: orgproc.organization_id = aauv.organization_id
3749: and

Line 5517: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;

5513: l_lob_tbl amw_scope_pvt.lob_tbl_type;
5514: l_org_tbl amw_scope_pvt.org_tbl_type;
5515: l_proc_tbl amw_scope_pvt.process_tbl_type;
5516:
5517: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5518: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5519:
5520: l_position NUMBER;
5521:

Line 5518: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;

5514: l_org_tbl amw_scope_pvt.org_tbl_type;
5515: l_proc_tbl amw_scope_pvt.process_tbl_type;
5516:
5517: l_sub_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5518: l_lob_vs AMW_AUDIT_UNITS_V.subsidiary_valueset%TYPE;
5519:
5520: l_position NUMBER;
5521:
5522: l_start_date DATE;

Line 5587: FROM amw_audit_units_v

5583: Concurrent Program***/
5584: begin
5585: SELECT company_code, lob_code
5586: into l_subsidiary_tbl(l_position).subsidiary_code, l_lob_tbl(l_position).lob_code
5587: FROM amw_audit_units_v
5588: WHERE organization_id = org_rec.organization_id;
5589:
5590: l_org_tbl(l_position).org_id := org_rec.organization_id;
5591: l_position := l_position + 1;

Line 5894: FROM amw_audit_units_v

5890: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC');
5891:
5892: CURSOR c_org IS
5893: SELECT subsidiary_valueset, company_code, lob_valueset, lob_code
5894: FROM amw_audit_units_v
5895: WHERE organization_id = p_organization_id;
5896:
5897: l_eval_opinion_id NUMBER;
5898: l_proc_pending_cert NUMBER;