APPS.PAY_SDB_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

    select
          defined_balance_id,
          balance_type_id,
          dimension_name,
          force_latest_balance_flag,
          grossup_allowed_flag,
          object_version_number
    ,     exclusion_rule_id
    from  pay_shadow_defined_balances
    where defined_balance_id = p_defined_balance_id;

Line: 131

    select 	defined_balance_id,
	balance_type_id,
	dimension_name,
        force_latest_balance_flag,
        grossup_allowed_flag,
	object_version_number
    ,   exclusion_rule_id
    from	pay_shadow_defined_balances
    where	defined_balance_id = p_defined_balance_id
    for	update nowait;