APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_CONTROL_RULES

Line 1091: FROM po_control_rules pocr

1087:
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

Line 1193: FROM po_control_rules pocr

1189: END IF;
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

Line 1850: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'

1846: -- 1 - key into po_session_gt table
1847: -- 2 - p_auth_check_ids.position_id
1848: -- 3 - p_auth_check_ids.job_id
1849: -- 4 - p_auth_check_ids.ctl_function_id
1850: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1851:
1852: x_range_check_sql := 'SELECT '
1853: || l_hint -- bug 12359144
1854: || ' sign(min(nvl(POCR.amount_limit, -1) '

Line 1856: || ' FROM po_session_gt pgt, po_control_rules pocr'

1852: x_range_check_sql := 'SELECT '
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

Line 1999: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'

1995: -- 1 - key into po_session_gt table
1996: -- 2 - p_auth_check_ids.position_id
1997: -- 3 - p_auth_check_ids.job_id
1998: -- 4 - p_auth_check_ids.ctl_function_id
1999: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
2000:
2001: x_range_check_sql := 'SELECT nvl(min(-1),0) '
2002: || ' FROM po_session_gt pgt '
2003: || l_flex_table

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))'