APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_CONTROL_GROUPS

Line 1092: , po_control_groups pocg

1088:
1089: SELECT sign(min(nvl(POCR.amount_limit, l_amt_limit_nvl) - sum(pgt.num1)))
1090: INTO l_result
1091: FROM po_control_rules pocr
1092: , po_control_groups pocg
1093: , po_position_controls popc
1094: , po_session_gt pgt
1095: WHERE pgt.key = p_session_gt_key
1096: AND pgt.num1 IS NOT NULL

Line 1194: , po_control_groups pocg

1190:
1191: SELECT sign(min(nvl(POCR.amount_limit, -1) - sum(pgt.num1)))
1192: INTO l_result
1193: FROM po_control_rules pocr
1194: , po_control_groups pocg
1195: , po_position_controls popc
1196: , po_session_gt pgt
1197: WHERE pgt.key = p_session_gt_key
1198: AND pgt.num1 IS NOT NULL

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

1853: || l_hint -- bug 12359144
1854: || ' sign(min(nvl(POCR.amount_limit, -1) '
1855: || ' - sum(' || l_sum_col || ')))'
1856: || ' FROM po_session_gt pgt, po_control_rules pocr'
1857: || ' , po_control_groups pocg, po_position_controls popc'
1858: || l_flex_table
1859: || ' WHERE pgt.key = :1 AND ' || l_sum_col || ' IS NOT NULL'
1860: || ' AND pgt.char1 = DECODE(POCR.RULE_TYPE_CODE,''INCLUDE'',nvl(pgt.char1, ''N''),''EXCLUDE'',''N'') ' --Bug 13835378 fix
1861: || ' AND pgt.char2 <> ''FINALLY CLOSED'' '

Line 2009: || ' FROM po_control_rules pocr, po_control_groups pocg'

2005: || ' AND pgt.char1 = ''N'' ' --Bug 13835378 fix. Cancelled lines should not be considered.
2006: || l_flex_join
2007: || ' AND NOT EXISTS ( '
2008: || ' SELECT ''account is in range'' '
2009: || ' FROM po_control_rules pocr, po_control_groups pocg'
2010: || ' , po_position_controls popc '
2011: --
2012: || ' WHERE ((:2 IS NULL) OR (popc.position_id = :3))'
2013: || ' AND ((:4 IS NULL) OR (popc.job_id = :5))'