APPS.AHL_ITEMCOMP_APPROVAL_PVT dependencies on AHL_ITEM_COMP_V

Line 45: ahl_item_comp_v

41: approval_status_code ,
42: effective_end_date ,
43: link_comp_id
44: FROM
45: ahl_item_comp_v
46: WHERE
47: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
48:
49: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 341: ahl_item_comp_v

337: APPROVAL_STATUS_CODE ,
338: EFFECTIVE_END_DATE ,
339: LINK_COMP_ID
340: FROM
341: ahl_item_comp_v
342: WHERE
343: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
344:
345: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 474: ahl_item_comp_v

470: APPROVAL_STATUS_CODE ,
471: EFFECTIVE_END_DATE ,
472: LINK_COMP_ID
473: FROM
474: ahl_item_comp_v
475: WHERE
476: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
477:
478: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 622: ahl_item_comp_v

618: APPROVAL_STATUS_CODE ,
619: EFFECTIVE_END_DATE ,
620: LINK_COMP_ID
621: FROM
622: ahl_item_comp_v
623: WHERE
624: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
625:
626: l_hyphen_pos1 NUMBER;

Line 771: ahl_item_comp_v

767: APPROVAL_STATUS_CODE ,
768: EFFECTIVE_END_DATE ,
769: LINK_COMP_ID
770: FROM
771: ahl_item_comp_v
772: WHERE
773: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
774:
775: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 924: ahl_item_comp_v

920: APPROVAL_STATUS_CODE ,
921: EFFECTIVE_END_DATE ,
922: LINK_COMP_ID
923: FROM
924: ahl_item_comp_v
925: WHERE
926: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
927:
928: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 1077: ahl_item_comp_v

1073: APPROVAL_STATUS_CODE ,
1074: EFFECTIVE_END_DATE ,
1075: LINK_COMP_ID
1076: FROM
1077: ahl_item_comp_v
1078: WHERE
1079: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
1080:
1081: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 1235: ahl_item_comp_v

1231: APPROVAL_STATUS_CODE ,
1232: EFFECTIVE_END_DATE ,
1233: LINK_COMP_ID
1234: FROM
1235: ahl_item_comp_v
1236: WHERE
1237: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
1238:
1239: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 1378: ahl_item_comp_v

1374: APPROVAL_STATUS_CODE ,
1375: EFFECTIVE_END_DATE ,
1376: LINK_COMP_ID
1377: FROM
1378: ahl_item_comp_v
1379: WHERE
1380: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
1381:
1382: l_item_comp_rec GetItemCompDet%ROWTYPE;

Line 1604: ahl_item_comp_v

1600: APPROVAL_STATUS_CODE ,
1601: EFFECTIVE_END_DATE ,
1602: LINK_COMP_ID
1603: FROM
1604: ahl_item_comp_v
1605: WHERE
1606: ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;
1607:
1608: l_item_comp_rec GetItemCompDet%ROWTYPE;