APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on AHL_WARRANTY_TEMPLATES_B

Line 330: FROM AHL_WARRANTY_TEMPLATES_B AWTB,

326: AWTB.PERIOD_UOM_CODE,
327: AWTB.CONTRACT_EXPIRY_TYPE,
328: AWTB.CLAIM_LABOUR_HOURS,
329: ASSOC.OSP_CLAIM_FLAG
330: FROM AHL_WARRANTY_TEMPLATES_B AWTB,
331: AHL_WARRANTY_TMPL_ITEMS ASSOC,
332: CSI_ITEM_INSTANCES INSTANCE
333: WHERE AWTB.WARRANTY_TEMPLATE_ID = c_warranty_template_id
334: AND INSTANCE.INSTANCE_ID = c_item_instance_id

Line 738: FROM AHL_WARRANTY_TEMPLATES_B

734: -- cursor to check template's end date validity
735: -- SATHAPLI::Bug 11655758, 27-Jan-2011, consider the template's default contract end date too
736: CURSOR chk_tmpl_end_date_csr (c_warranty_tmpl_id NUMBER) IS
737: SELECT 'X'
738: FROM AHL_WARRANTY_TEMPLATES_B
739: WHERE warranty_template_id = c_warranty_tmpl_id
740: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE)
741: AND TRUNC(NVL(contract_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
742:

Line 746: FROM AHL_WARRANTY_TEMPLATES_B

742:
743: -- cursor to check template's enabled flag
744: CURSOR chk_tmpl_flag_csr (c_warranty_tmpl_id NUMBER) IS
745: SELECT 'X'
746: FROM AHL_WARRANTY_TEMPLATES_B
747: WHERE warranty_template_id = c_warranty_tmpl_id
748: AND enabled_flag = 'Y';
749:
750: -- cursor to check template item's enabled flag