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 113: FROM por_template_info pti,

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