APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_POSITION_CONTROLS

Line 1077: , po_position_controls popc

1073: SELECT sign(min(nvl(POCR.amount_limit, l_amt_limit_nvl) - sum(pgt.num1)))
1074: INTO l_result
1075: FROM po_control_rules pocr
1076: , po_control_groups pocg
1077: , po_position_controls popc
1078: , po_session_gt pgt
1079: WHERE pgt.key = p_session_gt_key
1080: AND pgt.num1 IS NOT NULL
1081: AND pgt.num2 IS NULL -- Bug 4610058

Line 1179: , po_position_controls popc

1175: SELECT sign(min(nvl(POCR.amount_limit, -1) - sum(pgt.num1)))
1176: INTO l_result
1177: FROM po_control_rules pocr
1178: , po_control_groups pocg
1179: , po_position_controls popc
1180: , po_session_gt pgt
1181: WHERE pgt.key = p_session_gt_key
1182: AND pgt.num1 IS NOT NULL
1183: AND pgt.num2 IS NULL -- Bug 4610058

Line 1831: || ' , po_control_groups pocg, po_position_controls popc'

1827:
1828: x_range_check_sql := 'SELECT sign(min(nvl(POCR.amount_limit, -1) '
1829: || ' - sum(' || l_sum_col || ')))'
1830: || ' FROM po_session_gt pgt, po_control_rules pocr'
1831: || ' , po_control_groups pocg, po_position_controls popc'
1832: || l_flex_table
1833: || ' WHERE pgt.key = :1 AND ' || l_sum_col || ' IS NOT NULL'
1834: || ' AND pgt.char1 = ''N'' '
1835: || ' AND pgt.char2 <> ''FINALLY CLOSED'' '

Line 1983: || ' , po_position_controls popc '

1979: || l_flex_join
1980: || ' AND NOT EXISTS ( '
1981: || ' SELECT ''account is in range'' '
1982: || ' FROM po_control_rules pocr, po_control_groups pocg'
1983: || ' , po_position_controls popc '
1984: --
1985: || ' WHERE ((:2 IS NULL) OR (popc.position_id = :3))'
1986: || ' AND ((:4 IS NULL) OR (popc.job_id = :5))'
1987: --