APPS.PAY_HK_MPF SQL Statements

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

Line: 32

select ptp.time_period_id,
       bal.action_sequence,
       bal.balance_name||bal.database_item_suffix,
       ptp.start_date,
       ptp.end_date,
       bal.value,
       to_number(to_char(bal.effective_date,'MM'))
from   pay_hk_mpf_ri_balances_v   bal,
       per_time_periods           ptp
where  bal.assignment_id = p_assignment_id
and    bal.balance_name  = 'MPF_RI'
and    bal.payroll_id    = ptp.payroll_id
and    bal.expiry_date     between  ptp.start_date and ptp.end_date
and    ptp.end_date        between p_date_from and p_date_to
order by ptp.start_date, bal.action_sequence desc;

Line: 364

select      'S'
from        hr_organization_information d
           ,hr_all_organization_units b
where       to_number(d.org_information20) = to_number(p_entry_value)
and         b.business_group_id = p_bus_grp_id
and         b.organization_id = d.organization_id
and         d.org_information_context = 'HK_MPF_SCHEMES';

Line: 395

select      'S'
from        per_assignment_extra_info d
where       to_number(d.aei_information20) = to_number(p_entry_value)
and         d.assignment_id = p_assignment_id
and         d.aei_information_category = 'HR_QUARTERS_INFO_HK';

Line: 425

SELECT target.ACTUAL_TERMINATION_DATE
FROM
        per_periods_of_service                 target,
        per_assignments_f                      ASSIGN
WHERE   p_date BETWEEN ASSIGN.effective_start_date
                 AND ASSIGN.effective_end_date
AND    ASSIGN.assignment_id                  = p_assignment_id
AND    ASSIGN.assignment_type                = 'E'
AND    target.period_of_service_id           = ASSIGN.period_of_service_id;