APPS.PAY_IE_PRSI SQL Statements

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

Line: 56

SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
      paa.assignment_action_id),16))
FROM pay_assignment_actions paa
    ,pay_payroll_actions ppa
WHERE paa.assignment_id=p_assignment_id
  AND paa.payroll_action_id=ppa.payroll_action_id
  AND ppa.action_type in ('Q','B','R','I','V')
  AND ppa.action_status ='C'
  AND paa.source_action_id is null
  AND ppa.effective_date<= p_till_date;

Line: 67

SELECT pdb.defined_balance_id
FROM pay_balance_dimensions pbd
    ,pay_defined_balances  pdb
    ,pay_balance_types pbt
WHERE pbt.balance_name = p_balance_name
  AND pbt.legislation_code='IE'
  AND pbd.dimension_name =p_dimension_name
  AND pbd.legislation_code='IE'
  AND pdb.balance_dimension_id=pbd.balance_dimension_id
  AND pdb.balance_type_id=pbt.balance_type_id;

Line: 121

  cursor c_prsi_dtl is select contribution_class
                              ,overridden_subclass
                              ,soc_ben_flag
                              ,overridden_ins_weeks
                              ,community_flag
                              ,exemption_start_date
                              ,exemption_end_date
                         from  pay_ie_prsi_details_v pipd
                               ,pay_payroll_actions ppa
                        where  assignment_id = p_assignment_id
                          and  ppa.payroll_action_id = p_payroll_action_id
                          and  ppa.date_earned between pipd.effective_start_date and pipd.effective_end_date;

Line: 205

   select to_char(p_test_date, 'DAY') from sys.dual;

Line: 251

select pap.period_type
from   pay_all_payrolls_f pap
where  pap.payroll_id = p_payroll_id
and    p_session_date between pap.effective_start_date and pap.effective_end_date;

Line: 270

select ptp.start_date
from   per_time_periods ptp
where  ptp.payroll_id = p_payroll_id
and    p_session_date between ptp.start_date and ptp.end_date;

Line: 289

select ptp.end_date
from   per_time_periods ptp
where  ptp.payroll_id = p_payroll_id
and    p_session_date between ptp.start_date and ptp.end_date;