APPS.AMW_UTILITY_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 1462: amw_control_associations aca,

1458: BEGIN
1459: select
1460: count(1) into dummy_count
1461: from
1462: amw_control_associations aca,
1463: amw_process ap
1464: where
1465: aca.pk1 = ap.process_id
1466: and aca.object_type = 'RISK'

Line 1492: amw_control_associations aca,

1488: BEGIN
1489: select
1490: ((select count(1)
1491: from
1492: amw_control_associations aca,
1493: amw_process_vl apvl
1494: where
1495: aca.object_type = 'RISK'
1496: and aca.pk1 = apvl.process_id

Line 1504: amw_control_associations aca,

1500: and apvl.process_id = p_process_id and apvl.revision_number = p_revision_number)
1501: +
1502: (select count(1)
1503: from
1504: amw_control_associations aca,
1505: Amw_Proc_Hierarchy_Denorm aphd,
1506: amw_process ap
1507: where aphd.process_id = ap.process_id
1508: and aphd.up_down_ind = 'D'

Line 1889: from amw_control_associations

1885: l_dummy varchar2(1):='N';
1886: BEGIN
1887: IF p_appr_date is not null THEN
1888: select 'Y' into l_dummy
1889: from amw_control_associations
1890: where object_type = 'RISK_ORG'
1891: and pk1 = p_org_id
1892: and pk2 = p_process_id
1893: and pk3 = p_risk_id

Line 1897: from amw_control_associations

1893: and pk3 = p_risk_id
1894: and approval_date is not null and deletion_approval_date is null;
1895: ELSE
1896: select 'Y' into l_dummy
1897: from amw_control_associations
1898: where object_type = 'RISK_ORG'
1899: and pk1 = p_org_id
1900: and pk2 = p_process_id
1901: and pk3 = p_risk_id