APPS.HR_CAGR_FF_PKG SQL Statements

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

Line: 37

    select paf.business_group_id
	, paf.organization_id
	, paf.payroll_id
	, paf.person_id
	, scl.segment1
    from per_all_assignments_f paf,
	 hr_soft_coding_keyflex scl
    where paf.assignment_id = p_assignment_id
    and   p_effective_date between paf.effective_start_date
				and paf.effective_end_date
    and	  paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+);

Line: 50

    select  ff.formula_name
    from    ff_formulas_f ff
    where   ff.formula_id = p_formula_id
    and     p_effective_date between ff.effective_start_date
                                and ff.effective_end_date;