DBA Data[Home] [Help]

APPS.PAY_NCR_SHD SQL Statements

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

Line: 79

    select
		net_calculation_rule_id,
	accrual_plan_id,
	business_group_id,
	input_value_id,
	add_or_subtract,
	date_input_value_id,
	object_version_number
    from	pay_net_calculation_rules
    where	net_calculation_rule_id = p_net_calculation_rule_id;
Line: 156

    select 	net_calculation_rule_id,
	accrual_plan_id,
	business_group_id,
	input_value_id,
	add_or_subtract,
	date_input_value_id,
	object_version_number
    from	pay_net_calculation_rules
    where	net_calculation_rule_id = p_net_calculation_rule_id
    for	update nowait;