APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 2832: select distinct control_id from amw_control_associations

2828: if x.exists(1) then
2829: forall ctr in x.first .. x.last
2830: update amw_process
2831: set control_count = (select count(*) from (
2832: select distinct control_id from amw_control_associations
2833: where pk1 in ( ( select parent_child_id
2834: from amw_proc_hierarchy_denorm
2835: where process_id = x(ctr)
2836: and up_down_ind = 'D'

Line 2934: select distinct control_id from amw_control_associations

2930: if x.exists(1) then
2931: forall ctr in x.first .. x.last
2932: update amw_process
2933: set control_count = (select count(*) from (
2934: select distinct control_id from amw_control_associations
2935: where pk1 in ( (select parent_child_id
2936: from amw_proc_hierarchy_denorm
2937: where process_id = x(ctr)
2938: and up_down_ind = 'D'

Line 2993: select distinct control_id from amw_control_associations

2989: if x.exists(1) then
2990: forall ctr in x.first .. x.last
2991: update amw_process
2992: set control_count_latest = (select count(*) from (
2993: select distinct control_id from amw_control_associations
2994: where pk1 in ( ( select parent_child_id
2995: from amw_proc_hierarchy_denorm
2996: where process_id = x(ctr)
2997: and up_down_ind = 'D'

Line 3159: (select distinct control_id from amw_control_associations

3155: forall ctr in x.first .. x.last
3156: update amw_process
3157: set control_count_latest = (select count(*) from
3158:
3159: (select distinct control_id from amw_control_associations
3160: where pk1 in ((select parent_child_id
3161: from amw_proc_hierarchy_denorm
3162: where process_id = x(ctr)
3163: and up_down_ind = 'D'

Line 3192: (select distinct control_id from amw_control_associations

3188: )),
3189:
3190: control_count_latest = (select count(*) from
3191:
3192: (select distinct control_id from amw_control_associations
3193: where pk1 in ((select parent_child_id
3194: from amw_proc_hierarchy_denorm
3195: where process_id = x(ctr)
3196: and up_down_ind = 'D'

Line 3916: delete from amw_control_associations

3912: IF SQL%FOUND THEN
3913: l_risk_exists := TRUE;
3914: END IF;
3915:
3916: delete from amw_control_associations
3917: where pk1 = p_process_id
3918: and approval_date is null
3919: and object_type = 'RISK';
3920:

Line 3925: update amw_control_associations

3921: IF SQL%FOUND THEN
3922: l_control_exists := TRUE;
3923: END IF;
3924:
3925: update amw_control_associations
3926: set deletion_date = null
3927: where pk1 = p_process_id
3928: and object_type = 'RISK'
3929: and deletion_date is not null