DBA Data[Home] [Help]

APPS.ARH_ADDR_PKG dependencies on ARPT_SQL_FUNC_UTIL

Line 2086: 'Y' = arpt_sql_func_util.get_posted_flag

2082: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2083: and ct.customer_trx_id = ctl.customer_trx_id
2084: and 'TAX' = ctl.line_type
2085: and (
2086: 'Y' = arpt_sql_func_util.get_posted_flag
2087: ( ct.customer_trx_id,
2088: ctt.post_to_gl,
2089: ct.complete_flag
2090: ) -- posted_flag

Line 2091: OR 'Y' = arpt_sql_func_util.get_activity_flag

2087: ( ct.customer_trx_id,
2088: ctt.post_to_gl,
2089: ct.complete_flag
2090: ) -- posted_flag
2091: OR 'Y' = arpt_sql_func_util.get_activity_flag
2092: ( ct.customer_trx_id,
2093: ctt.accounting_affect_flag,
2094: ct.complete_flag,
2095: ctt.type,

Line 2126: 'Y' = arpt_sql_func_util.get_posted_flag

2122: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2123: and ct.customer_trx_id = ctl.customer_trx_id
2124: and 'TAX' = ctl.line_type
2125: and (
2126: 'Y' = arpt_sql_func_util.get_posted_flag
2127: ( ct.customer_trx_id,
2128: ctt.post_to_gl,
2129: ct.complete_flag
2130: ) -- posted_flag

Line 2131: OR 'Y' = arpt_sql_func_util.get_activity_flag

2127: ( ct.customer_trx_id,
2128: ctt.post_to_gl,
2129: ct.complete_flag
2130: ) -- posted_flag
2131: OR 'Y' = arpt_sql_func_util.get_activity_flag
2132: ( ct.customer_trx_id,
2133: ctt.accounting_affect_flag,
2134: ct.complete_flag,
2135: ctt.type,

Line 2246: 'Y' = arpt_sql_func_util.get_posted_flag

2242: and nvl(ct.org_id, -99) = nvl(ctt.org_id, -99)
2243: and ct.customer_trx_id = ctl.customer_trx_id
2244: and 'TAX' = ctl.line_type
2245: and (
2246: 'Y' = arpt_sql_func_util.get_posted_flag
2247: ( ct.customer_trx_id,
2248: ctt.post_to_gl,
2249: ct.complete_flag
2250: ) -- posted_flag

Line 2251: OR 'Y' = arpt_sql_func_util.get_activity_flag

2247: ( ct.customer_trx_id,
2248: ctt.post_to_gl,
2249: ct.complete_flag
2250: ) -- posted_flag
2251: OR 'Y' = arpt_sql_func_util.get_activity_flag
2252: ( ct.customer_trx_id,
2253: ctt.accounting_affect_flag,
2254: ct.complete_flag,
2255: ctt.type,

Line 2295: 'Y' = arpt_sql_func_util.get_posted_flag

2291: and nvl(ct.org_id,-99) = nvl(ctt.org_id, -99)
2292: and ct.customer_trx_id = ctl.customer_trx_id
2293: and 'TAX' = ctl.line_type
2294: and (
2295: 'Y' = arpt_sql_func_util.get_posted_flag
2296: ( ct.customer_trx_id,
2297: ctt.post_to_gl,
2298: ct.complete_flag
2299: ) -- posted_flag

Line 2300: OR 'Y' = arpt_sql_func_util.get_activity_flag

2296: ( ct.customer_trx_id,
2297: ctt.post_to_gl,
2298: ct.complete_flag
2299: ) -- posted_flag
2300: OR 'Y' = arpt_sql_func_util.get_activity_flag
2301: ( ct.customer_trx_id,
2302: ctt.accounting_affect_flag,
2303: ct.complete_flag,
2304: ctt.type,