APPS.AMW_UTILITY_PVT dependencies on AMW_PROCESS_ORGANIZATION

Line 1040: from amw_process_organization

1036: where process_id = p_pk;
1037: elsif p_objectContext = 'PROCESS_ORG' then
1038: select Process_Owner_Id
1039: into process_owner_id
1040: from amw_process_organization
1041: where process_organization_id = p_pk;
1042: end if;
1043:
1044: select person_party_id

Line 1226: from amw_process_organization apo,

1222: is
1223: l_display_name amw_process_names_tl.display_name%type;
1224: begin
1225: select display_name into l_display_name
1226: from amw_process_organization apo,
1227: amw_process_names_tl amwp_tl
1228: where apo.approval_date is not null
1229: and apo.approval_end_date is null
1230: and apo.rl_process_rev_id = amwp_tl.process_rev_id

Line 1920: from amw_process_organization

1916: l_dummy varchar2(1):='N';
1917: BEGIN
1918: -- for the time being we just check for the existance of -2 row in org.if it present then the org is usable to assign processes.
1919: select 'Y' into l_dummy
1920: from amw_process_organization
1921: where organization_id = p_org_id
1922: and process_id = -2;
1923: return l_dummy;
1924: EXCEPTION