APPS.HZ_DSS_UTIL_PUB dependencies on AR_LOOKUPS

Line 145: FROM ar_lookups lu

141: AND ROWNUM = 1;
142:
143: CURSOR c_check_operation_code IS
144: SELECT '1'
145: FROM ar_lookups lu
146: WHERE lu.lookup_type = 'HZ_DATA_OPERATIONS'
147: AND lu.lookup_code = p_operation_code;
148:
149: CURSOR get_functions_for_op IS

Line 398: from ar_lookups lu

394: begin
395:
396: select '1'
397: into l_exists
398: from ar_lookups lu
399: where lu.lookup_type = 'HZ_DATA_OPERATIONS'
400: and lu.lookup_code = p_operation_code;
401:
402: exception when no_data_found then

Line 511: AND owner_table_name = 'AR_LOOKUPS'

507: ) IS
508: SELECT 1
509: FROM hz_dss_criteria
510: WHERE dss_group_code = p_dss_group_code
511: AND owner_table_name = 'AR_LOOKUPS'
512: AND owner_table_id1 = 'HZ_CREATED_BY_MODULES'
513: AND status = 'A'
514: AND ROWNUM = 1;
515:

Line 1547: AND owner_table_name = 'AR_LOOKUPS'

1543: AND p.created_by_module IN (
1544: SELECT owner_table_id2
1545: FROM hz_dss_criteria
1546: WHERE dss_group_code = p_dss_group_code
1547: AND owner_table_name = 'AR_LOOKUPS'
1548: AND owner_table_id1 = 'HZ_CREATED_BY_MODULES'
1549: AND status = 'A');
1550:
1551: l_falling_into_the_group VARCHAR2(2);