APPS.PAY_PYGBNICV_XMLP_PKG SQL Statements

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

Line: 19

    select consolidation_set_name
    into   c_consolidation_set
    from   pay_consolidation_sets
    where  consolidation_set_id = p_consolidation_set;

Line: 29

    select assignment_set_name
    into   c_assignment_set
    from   hr_assignment_sets
    where  assignment_set_id = p_assignment_set;