APPS.HXC_FF_DICT SQL Statements

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

Line: 31

SELECT	asg.assignment_id
FROM	per_assignments_f asg
WHERE	asg.person_id	= p_resource_id
AND	p_submission_date BETWEEN
	asg.effective_start_date AND asg.effective_end_date
AND	asg.primary_flag = 'Y'
AND	asg.assignment_type in ('E','C');

Line: 280

SELECT	df.end_user_column_name
,	df.application_column_name
FROM
	fnd_descr_Flex_Column_usages df
WHERE
        df.application_id               = 809            AND
	df.descriptive_flexfield_name	= 'OTL Formulas' AND
	df.descriptive_flex_context_code= p_formula_name
ORDER BY
	df.application_column_name;

Line: 299

SELECT  htc.time_category_id
,       htc.time_category_name
FROM	hxc_time_categories htc
,	pay_accrual_plans pap
WHERE
	pap.accrual_plan_id = p_accrual_plan_id
AND (
	( htc.time_category_name = SUBSTR('OTL_DEC_'||pap.accrual_plan_name,1,90))
      OR
	( htc.time_category_name = SUBSTR('OTL_INC_'||pap.accrual_plan_name,1,90))
    );

Line: 855

SELECT	MIN( asg.effective_start_date)
FROM	per_assignments_f asg
WHERE	asg.person_id	= p_resource_id
AND	asg.primary_flag = 'Y'
AND	asg.assignment_type in ('E','C');