APPS.POR_IFT_INFO_PKG dependencies on POR_TEMPLATE_INFO

Line 36: FROM POR_TEMPLATE_INFO INFO,

32: AND VAL.FLEX_VALUE_SET_ID = ATB.FLEX_VALUE_SET_ID
33: AND VAL.FLEX_VALUE_ID = VTL.FLEX_VALUE_ID
34: AND VTL.LANGUAGE = NVL(p_preparer_language, USERENV('LANG')))) value,
35: TMPT.TEMPLATE_NAME
36: FROM POR_TEMPLATE_INFO INFO,
37: POR_TEMPLATES_ALL_B TMPB,
38: POR_TEMPLATES_ALL_TL TMPT,
39: POR_TEMPLATE_ATTRIBUTES_B ATB,
40: POR_TEMPLATE_ATTRIBUTES_TL ATT

Line 112: FROM por_template_info pti,

108: CURSOR c_req_id IS
109: SELECT porl.requisition_header_id,
110: porl.requisition_line_id,
111: NVL(MAX(porl.created_by), 1) AS created_by
112: FROM por_template_info pti,
113: po_requisition_lines_all porl
114: WHERE porl.requisition_header_id = p_req_header_id
115: AND porl.requisition_line_id = pti.requisition_line_id
116: GROUP BY porl.requisition_header_id,