APPS.AHL_ITEMGROUPS_APPROVAL_PVT dependencies on AHL_ITEM_GROUPS_VL

Line 44: ahl_item_groups_vl

40: status_code ,
41: type_code ,
42: source_item_group_id
43: FROM
44: ahl_item_groups_vl
45: WHERE
46: item_group_id =c_item_group_id;
47:
48: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 305: ahl_item_groups_vl

301: status_code ,
302: type_code ,
303: source_item_group_id
304: FROM
305: ahl_item_groups_vl
306: WHERE
307: item_group_id =c_item_group_id;
308:
309: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 438: ahl_item_groups_vl

434: status_code ,
435: type_code ,
436: source_item_group_id
437: FROM
438: ahl_item_groups_vl
439: WHERE
440: item_group_id =c_item_group_id;
441:
442: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 584: ahl_item_groups_vl

580: status_code ,
581: type_code ,
582: source_item_group_id
583: FROM
584: ahl_item_groups_vl
585: WHERE
586: item_group_id =c_item_group_id;
587:
588: l_hyphen_pos1 NUMBER;

Line 731: ahl_item_groups_vl

727: status_code ,
728: type_code ,
729: source_item_group_id
730: FROM
731: ahl_item_groups_vl
732: WHERE
733: item_group_id =c_item_group_id;
734:
735: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 883: ahl_item_groups_vl

879: status_code ,
880: type_code ,
881: source_item_group_id
882: FROM
883: ahl_item_groups_vl
884: WHERE
885: item_group_id =c_item_group_id;
886:
887: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 1036: ahl_item_groups_vl

1032: status_code ,
1033: type_code ,
1034: source_item_group_id
1035: FROM
1036: ahl_item_groups_vl
1037: WHERE
1038: item_group_id =c_item_group_id;
1039:
1040: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 1194: ahl_item_groups_vl

1190: status_code ,
1191: type_code ,
1192: source_item_group_id
1193: FROM
1194: ahl_item_groups_vl
1195: WHERE
1196: item_group_id =c_item_group_id;
1197:
1198: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 1341: ahl_item_groups_vl

1337: status_code ,
1338: type_code ,
1339: source_item_group_id
1340: FROM
1341: ahl_item_groups_vl
1342: WHERE
1343: item_group_id =c_item_group_id;
1344:
1345: l_item_group_rec GetItemGroupDet%ROWTYPE;

Line 1580: ahl_item_groups_vl

1576: status_code ,
1577: type_code ,
1578: source_item_group_id
1579: FROM
1580: ahl_item_groups_vl
1581: WHERE
1582: item_group_id =c_item_group_id;
1583:
1584: l_item_group_rec GetItemGroupDet%ROWTYPE;