APPS.PAY_NL_RULES SQL Statements

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

Line: 24

select fnd_date.DATE_TO_CANONICAL(ppa.effective_date)
from pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id=p_retro_asg_action_id
and ppa.payroll_action_id=paa.payroll_action_id ;

Line: 52

select prc.retro_component_id
from
pay_retro_components prc,
pay_retro_component_usages prcu
where
prcu.creator_id=cp_element_type_id
and prc.retro_component_id=prcu.retro_component_id
and prc.legislation_code='NL'
and prc.component_name in ('Correction','Adjustment')
and prcu.default_component = 'Y';

Line: 65

select prc.retro_component_id
from
pay_retro_components prc,
pay_retro_component_usages prcu
where
prcu.creator_id=cp_element_type_id
and prc.retro_component_id=prcu.retro_component_id
and prc.legislation_code='NL'
and prc.component_name='Replacement';

Line: 77

    Select hoi.org_information2
    from    hr_organization_information hoi
    where  hoi.org_information_context = 'NL_BG_INFO'
    and     hoi.organization_id         = p_business_group_id;

Line: 85

select distinct paa.business_group_id
from per_all_assignments_f paa
,pay_element_entries_f pee
where  pee.element_entry_id=p_ee_id
and pee.assignment_id=paa.assignment_id;

Line: 136

    SELECT DECODE(pay_nl_rules.get_object_group_type
                 ,'EMPLOYER'
                 ,prl_information1
                 ,substr(pap.payroll_name,1,30))
    FROM   per_all_assignments_f    paa
          ,pay_all_payrolls_f       pap
    WHERE  paa.assignment_id        = p_assignment_id
    AND    paa.payroll_id           = pap.payroll_id
    AND    paa.effective_start_date <= p_effective_end_date
    AND    paa.effective_end_date   >= p_effective_start_date
    AND    pap.effective_start_date <= p_effective_end_date
    AND    pap.effective_end_date   >= p_effective_start_date
    ORDER BY paa.effective_end_date DESC ,pap.effective_end_date DESC;

Line: 167

	select NVL(asg.establishment_id,prl_information1) from
 	       per_all_assignments_f asg,
	       pay_all_payrolls_f pap
	where  assignment_id = p_assignment_id
	       and asg.payroll_id = pap.payroll_id
	       and p_effective_date between asg.effective_start_date and asg.effective_end_date
	       and p_effective_date between pap.effective_start_date and pap.effective_end_date;

Line: 192

    SELECT org_information6
    FROM  hr_organization_information
    WHERE organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
    AND   org_information_context = 'NL_BG_INFO';