DBA Data[Home] [Help]

APPS.AMW_SCOPE_PVT dependencies on AMW_AUDIT_TASKS_V

Line 1911: amw_audit_tasks_v pt1,

1907: amw_audit_procedures_b aapb,
1908: amw_ap_tasks apt,
1909: amw_control_associations aca,
1910: amw_audit_projects_v pp,
1911: amw_audit_tasks_v pt1,
1912: amw_audit_tasks_v pt2
1913: WHERE apa.object_type = 'CTRL_ORG'
1914: AND aca.object_type='PROJECT'
1915: AND aca.pk1 = p_audit_project_id

Line 1912: amw_audit_tasks_v pt2

1908: amw_ap_tasks apt,
1909: amw_control_associations aca,
1910: amw_audit_projects_v pp,
1911: amw_audit_tasks_v pt1,
1912: amw_audit_tasks_v pt2
1913: WHERE apa.object_type = 'CTRL_ORG'
1914: AND aca.object_type='PROJECT'
1915: AND aca.pk1 = p_audit_project_id
1916: AND aca.pk2 = scope_rec.organization_id

Line 1985: amw_audit_tasks_v pt2

1981: amw_ap_tasks apt,
1982: amw_control_associations aca,
1983: amw_audit_projects_v pp,
1984: amw_template_tasks_v pt1,
1985: amw_audit_tasks_v pt2
1986: WHERE apa.object_type = 'CTRL_ORG'
1987: AND aca.object_type='PROJECT'
1988: AND aca.pk1 = p_audit_project_id
1989: AND aca.pk2 = scope_rec.organization_id

Line 2308: amw_audit_tasks_v pt1,

2304: amw_audit_procedures_b aapb,
2305: amw_ap_tasks apt,
2306: amw_control_associations aca,
2307: amw_audit_projects_v pp,
2308: amw_audit_tasks_v pt1,
2309: amw_audit_tasks_v pt2
2310: WHERE apa.object_type = 'ENTITY_AP'
2311: AND aca.object_type='PROJECT'
2312: AND aca.pk1 = p_audit_project_id

Line 2309: amw_audit_tasks_v pt2

2305: amw_ap_tasks apt,
2306: amw_control_associations aca,
2307: amw_audit_projects_v pp,
2308: amw_audit_tasks_v pt1,
2309: amw_audit_tasks_v pt2
2310: WHERE apa.object_type = 'ENTITY_AP'
2311: AND aca.object_type='PROJECT'
2312: AND aca.pk1 = p_audit_project_id
2313: AND aca.pk2 = scope_org_rec.organization_id

Line 2380: amw_audit_tasks_v pt2

2376: amw_ap_tasks apt,
2377: amw_control_associations aca,
2378: amw_audit_projects_v pp,
2379: amw_template_tasks_v pt1,
2380: amw_audit_tasks_v pt2
2381: WHERE apa.object_type = 'ENTITY_AP'
2382: AND aca.object_type='PROJECT'
2383: AND aca.pk1 = p_audit_project_id
2384: AND aca.pk2 = scope_org_rec.organization_id