APPS.AMW_ORG_HIERARCHY_PKG dependencies on AMW_PROC_HIERARCHY_DENORM

Line 2861: from amw_proc_hierarchy_denorm

2857: )
2858: IS
2859: cursor c1 (pid number) is
2860: select parent_child_id process_to_count
2861: from amw_proc_hierarchy_denorm
2862: where process_id = pid
2863: and up_down_ind = 'D'
2864: and hierarchy_type = 'A'
2865: union

Line 2915: from amw_proc_hierarchy_denorm

2911:
2912:
2913: cursor c_processes (pid number) is
2914: select parent_child_id process_to_count
2915: from amw_proc_hierarchy_denorm
2916: where process_id = pid
2917: and up_down_ind = 'D'
2918: and hierarchy_type = 'A'
2919: union

Line 3031: from amw_proc_hierarchy_denorm APHD

3027: where AP.approval_date is not null
3028: and AP.approval_end_date is null
3029: and AP.process_id <> -1
3030: and AP.process_id IN (select APHD.parent_child_id process_to_count
3031: from amw_proc_hierarchy_denorm APHD
3032: where APHD.process_id = p_process_id
3033: and APHD.up_down_ind = 'D'
3034: and APHD.hierarchy_type = 'A'
3035: union

Line 3440: from amw_proc_hierarchy_denorm

3436: l_msg_data varchar2(4000);
3437:
3438: cursor c_processes (pid number) is
3439: select parent_child_id process_to_count
3440: from amw_proc_hierarchy_denorm
3441: where process_id = pid
3442: and up_down_ind = 'D'
3443: and hierarchy_type = 'A'
3444: union

Line 3770: from amw_proc_hierarchy_denorm

3766:
3767:
3768: cursor c1 (pid number) is
3769: select parent_child_id process_to_count
3770: from amw_proc_hierarchy_denorm
3771: where process_id = pid
3772: and up_down_ind = 'D'
3773: and hierarchy_type = 'A'
3774: union

Line 4033: from amw_proc_hierarchy_denorm

4029: IS
4030:
4031: cursor c1 (pid number) is
4032: select parent_child_id process_to_count
4033: from amw_proc_hierarchy_denorm
4034: where process_id = pid
4035: and up_down_ind = 'D'
4036: and hierarchy_type = 'A'
4037: union

Line 4361: from amw_proc_hierarchy_denorm

4357: IS
4358:
4359: cursor c1 (pid number) is
4360: select parent_child_id process_to_count
4361: from amw_proc_hierarchy_denorm
4362: where process_id = pid
4363: and up_down_ind = 'D'
4364: and hierarchy_type = 'A';
4365:

Line 7828: from amw_proc_hierarchy_denorm

7824:
7825:
7826: cursor c1 (pid number) is
7827: select parent_child_id process_to_count
7828: from amw_proc_hierarchy_denorm
7829: where process_id = pid
7830: and up_down_ind = 'D'
7831: and hierarchy_type = 'A';
7832:

Line 8170: from amw_proc_hierarchy_denorm

8166: l_dummy number;
8167:
8168: cursor c1 (pid number) is
8169: select parent_child_id process_to_count
8170: from amw_proc_hierarchy_denorm
8171: where process_id = pid
8172: and up_down_ind = 'D'
8173: and hierarchy_type = 'A'
8174: union

Line 8354: from amw_proc_hierarchy_denorm

8350: pending_approval_exception exception;
8351:
8352: cursor c1 (pid number) is
8353: select parent_child_id process_to_count
8354: from amw_proc_hierarchy_denorm
8355: where process_id = pid
8356: and up_down_ind = 'D'
8357: and hierarchy_type = 'A'
8358: union

Line 8363: from amw_proc_hierarchy_denorm

8359: select pid process_to_count from dual;
8360:
8361: cursor c_processes (pid number) is
8362: select parent_child_id process_to_count
8363: from amw_proc_hierarchy_denorm
8364: where process_id = pid
8365: and up_down_ind = 'D'
8366: and hierarchy_type = 'A'
8367: union

Line 8523: from amw_proc_hierarchy_denorm APHD

8519: where AP.approval_date is not null
8520: and AP.approval_end_date is null
8521: and AP.process_id <> -1
8522: and AP.process_id IN ( select APHD.parent_child_id process_to_count
8523: from amw_proc_hierarchy_denorm APHD
8524: where APHD.process_id = p_process_id
8525: and APHD.up_down_ind = 'D'
8526: and APHD.hierarchy_type = 'A'
8527: union

Line 8600: from amw_proc_hierarchy_denorm

8596: )
8597: IS
8598: cursor c1 (pid number) is
8599: select parent_child_id process_to_count
8600: from amw_proc_hierarchy_denorm
8601: where process_id = pid
8602: and up_down_ind = 'D'
8603: and hierarchy_type = 'A'
8604: union

Line 8654: from amw_proc_hierarchy_denorm

8650:
8651:
8652: cursor c_processes (pid number) is
8653: select parent_child_id process_to_count
8654: from amw_proc_hierarchy_denorm
8655: where process_id = pid
8656: and up_down_ind = 'D'
8657: and hierarchy_type = 'A'
8658: union