APPS.PAY_SE_GENERAL SQL Statements

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

Line: 40

	    select amount1,amount2,amount3,amount4,amount5
	    INTO  l_amount1,l_amount2,l_amount3,l_amount4,l_amount5
	    from  pay_range_tables_f PRTF ,pay_ranges_f PRF,per_all_assignments_f  PAAF
	    where PAAF.ASSIGNMENT_ID = p_ASSIGNMENT_ID
            --and   PAAF.BUSINESS_GROUP_ID =  PRTF.BUSINESS_GROUP_ID
            and   PRTF.LEGISLATION_CODE='SE'
            and   PRTF.range_table_id = PRF.range_table_id
	    and   PRTF.range_table_number = TO_NUMBER(TO_CHAR(p_Tax_Table_No))
	    and   PRTF.period_frequency = PERIOD
	    and   PRTF.row_value_uom = ROM
	    and   Tax_Base
	                   between PRF.low_band
	                   and     PRF.high_band
	    and     p_DATE_EARNED between
	                                  PRTF.EFFECTIVE_START_DATE
	                              and PRTF.EFFECTIVE_END_DATE
	    and     p_DATE_EARNED between
	                                  PAAF.EFFECTIVE_START_DATE
	                              and PAAF.EFFECTIVE_END_DATE
	    and     p_DATE_EARNED between
	                                  PRF.EFFECTIVE_START_DATE
	                              and PRF.EFFECTIVE_END_DATE;

Line: 66

	    select  floor((months_between(TRUNC(p_DATE_EARNED,'yyyy') ,PAPF.DATE_OF_BIRTH ))/12)
	    from    per_all_assignments_f  PAAF,per_all_people_f PAPF
	    where   PAAF.ASSIGNMENT_ID =p_ASSIGNMENT_ID
	    and     PAAF.PERSON_ID = PAPF.PERSON_ID
	    and     PAAF.BUSINESS_GROUP_ID= PAPF.BUSINESS_GROUP_ID
	    and     p_DATE_EARNED between
	                                  PAPF.EFFECTIVE_START_DATE
	                              and PAPF.EFFECTIVE_END_DATE
	    and     p_DATE_EARNED between
	                                  PAAF.EFFECTIVE_START_DATE
	                              and PAAF.EFFECTIVE_END_DATE;

Line: 226

  SELECT eev1.screen_entry_value  screen_entry_value
   FROM   per_all_assignments_f      asg1
         ,per_all_assignments_f      asg2
         ,per_all_people_f           per
         ,pay_element_links_f        el
         ,pay_element_types_f        et
         ,pay_input_values_f         iv1
         ,pay_element_entries_f      ee
         ,pay_element_entry_values_f eev1
   WHERE  asg1.assignment_id    = P_ASSIGNMENT_ID
     AND p_DATE_EARNED BETWEEN asg1.effective_start_date AND asg1.effective_end_date
     AND p_DATE_EARNED BETWEEN per.effective_start_date AND per.effective_end_date
     AND p_DATE_EARNED BETWEEN asg2.effective_start_date AND asg2.effective_end_date
     AND  per.person_id         = asg1.person_id
     AND  asg2.person_id        = per.person_id
     AND  asg2.primary_flag     = 'Y'
     AND  et.element_name       = 'Tax Card'
     AND  et.legislation_code   = 'SE'
     AND  iv1.element_type_id   = et.element_type_id
     AND  iv1.name              = csr_v_input_value
     AND  el.business_group_id  = per.business_group_id
     AND  el.element_type_id    = et.element_type_id
     AND  ee.assignment_id      = asg2.assignment_id
     AND  ee.element_link_id    = el.element_link_id
     AND  eev1.element_entry_id = ee.element_entry_id
     AND  eev1.input_value_id   = iv1.input_value_id
     AND  p_DATE_EARNED BETWEEN ee.effective_start_date AND ee.effective_end_date
     AND  p_DATE_EARNED BETWEEN eev1.effective_start_date AND eev1.effective_end_date;

Line: 356

select end_date from per_time_periods
where payroll_id = p_PAYROLL_ID
and to_char(end_date,'YYYY') = to_char(p_CURR_PAY_END_DATE,'YYYY')
and rownum < 2
order by end_date;

Line: 364

select count(*) from per_time_periods
where payroll_id = p_PAYROLL_ID
and to_char(end_date,'YYYY') = to_char(l_first_end_date,'YYYY')
and p_CURR_PAY_END_DATE >= end_date --DBI Item, Current Payroll End Date
and l_mdate <= end_date; --Variable, Current Year First Period End Date OR Join Date, whichever is Max

Line: 414

select Hourly_Salaried_Code,segment9 from
per_all_assignments_f paaf,
hr_soft_coding_keyflex hsck
where
paaf.assignment_id= p_ASG_id  --20805
and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
and p_Effective_Date between
paaf.effective_start_date and paaf.effective_end_date;

Line: 431

 SELECT CSSB.SCHEDULE_ID
    from
    CAC_SR_SCHDL_OBJECTS CSSO,
    CAC_SR_SCHEDULES_B CSSB
    where
    CSSO.OBJECT_TYPE = b_object_type
    AND CSSO.OBJECT_ID = b_object_id
    AND CSSO.START_DATE_ACTIVE <= b_end_dt
    AND CSSO.END_DATE_ACTIVE >= b_start_dt
    AND CSSO.SCHEDULE_ID = CSSB.SCHEDULE_ID
    AND CSSB.DELETED_DATE IS NULL
    AND (CSSB.SCHEDULE_CATEGORY = b_schdl_cat
         OR CSSB.SCHEDULE_ID IN (SELECT SCHEDULE_ID
                                 FROM CAC_SR_PUBLISH_SCHEDULES
                                 WHERE OBJECT_TYPE = b_object_type
                                 AND OBJECT_ID = b_object_id
                                 AND b_schdl_cat IS NULL
                                ));

Line: 451

select CSTB.Template_Id,CSTB.TEMPLATE_LENGTH_DAYS from CAC_SR_SCHEDULES_B CSSB,
CAC_SR_TEMPLATES_B CSTB
where
CSSB.Template_Id=CSTB.Template_Id
and CSSB.Schedule_id=b_schedule_id; --10206

Line: 459

select CSRB.DURATION from
CAC_SR_TEMPLATES_B CSTB,
CAC_SR_TMPL_DETAILS CSTD,
CAC_SR_PERIODS_B CSRB
where
CSTB.Template_id =CSTD.Template_Id
and CSTD.Child_Period_Id=CSRB.Period_ID
and CSTB.Template_Id=b_template_id; --10284