APPS.PAY_AE_USER_FUNCTION SQL Statements

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

Line: 80

  SELECT id_flex_num
  FROM FND_ID_FLEX_STRUCTURES_VL
  WHERE (ID_FLEX_STRUCTURE_CODE = 'AE_STATUTORY_INFO')
  and (APPLICATION_ID=800)
  and (ID_FLEX_CODE='SCL') ;

Line: 86

    select  HOI2.org_information1
    from    hr_organization_units HOU
            ,hr_organization_information HOI1
            ,hr_organization_information HOI2
            ,hr_soft_coding_keyflex HSCK
            ,per_all_assignments_f PAA
    where   HOU.business_group_id = p_business_group_id
    and    trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
	to_date('4712/12/31','YYYY/MM/DD'))
    and   HOU.organization_id = HOI1.organization_id
    and   HOI1.org_information_context = 'CLASS'
    and   HOI1.org_information1 = 'HR_LEGAL_EMPLOYER'
    and   HOI1.organization_id = HOI2.organization_id
    and   PAA.assignment_id = p_assignment_id
    and   trunc(p_date_earned) between PAA.effective_start_date and PAA.effective_end_date
    and   PAA.soft_coding_keyflex_id = HSCK.soft_coding_keyflex_id
    and   HSCK.id_flex_num = p_id_flex_num
    and   decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
    and   HOI2.org_information_context = 'AE_REFERENCE_FF';

Line: 181

  SELECT id_flex_num
  FROM FND_ID_FLEX_STRUCTURES_VL
  WHERE (ID_FLEX_STRUCTURE_CODE = 'AE_STATUTORY_INFO')
  and (APPLICATION_ID=800)
  and (ID_FLEX_CODE='SCL') ;

Line: 187

    select  HOI2.org_information1
    from    hr_organization_units HOU
            ,hr_organization_information HOI1
            ,hr_organization_information HOI2
            ,hr_soft_coding_keyflex HSCK
            ,per_all_assignments_f PAA
    where   HOU.business_group_id = p_business_group_id
    and    trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
	to_date('4712/12/31','YYYY/MM/DD'))
    and   HOU.organization_id = HOI1.organization_id
    and   HOI1.org_information_context = 'CLASS'
    and   HOI1.org_information1 = 'HR_LEGAL_EMPLOYER'
    and   HOI1.organization_id = HOI2.organization_id
    and   PAA.assignment_id = p_assignment_id
    and   trunc(p_date_earned) between PAA.effective_start_date and PAA.effective_end_date
    and   PAA.soft_coding_keyflex_id = HSCK.soft_coding_keyflex_id
    and   HSCK.id_flex_num = p_id_flex_num
    and   decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
    and   HOI2.org_information_context = 'AE_OTHER_NAT_REFERENCE_FF';

Line: 284

    SELECT id_flex_num
    FROM FND_ID_FLEX_STRUCTURES_VL
    WHERE (ID_FLEX_STRUCTURE_CODE = 'AE_STATUTORY_INFO')
    and (APPLICATION_ID=800)
    and (ID_FLEX_CODE='SCL') ;

Line: 290

    select  HOI2.org_information2
    from    hr_organization_units HOU
            ,hr_organization_information HOI1
            ,hr_organization_information HOI2
            ,hr_soft_coding_keyflex HSCK
            ,per_all_assignments_f PAA
    where   HOU.business_group_id = p_business_group_id
    and    trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
	to_date('4712/12/31','YYYY/MM/DD'))
    and   HOU.organization_id = HOI1.organization_id
    and   HOI1.org_information_context = 'CLASS'
    and   HOI1.org_information1 = 'HR_LEGAL_EMPLOYER'
    and   HOI1.organization_id = HOI2.organization_id
    and   PAA.assignment_id = p_assignment_id
    and   trunc(p_date_earned) between PAA.effective_start_date and PAA.effective_end_date
    and   PAA.soft_coding_keyflex_id = HSCK.soft_coding_keyflex_id
    and   HSCK.id_flex_num = p_id_flex_num
    and   decode(HSCK.id_flex_num,p_id_flex_num,to_number(HSCK.segment1),-9999) = HOU.organization_id
    and   HOI2.org_information_context = 'AE_OTHER_NAT_REFERENCE_FF';