DBA Data[Home] [Help]

APPS.FLM_KANBAN_CONSOLIDATION dependencies on HR_LOCATIONS

Line 557: hr_locations loc,

553: l_sql_stmt_no := 40;
554: select distinct org.location_id
555: into l_deliver_location_id
556: from hr_organization_units org,
557: hr_locations loc,
558: po_location_associations_all pla
559: where org.organization_id =
560: l_kanban_card_Rec_Tbl(1).Organization_id
561: and org.location_id = loc.location_id

Line 570: hr_locations loc

566: l_sql_stmt_no := 40;
567: select org.location_id
568: into l_deliver_location_id
569: from hr_organization_units org,
570: hr_locations loc
571: where org.organization_id =
572: l_kanban_card_Rec_Tbl(1).Organization_id
573: and org.location_id = loc.location_id;
574: end if;