APPS.PER_ZA_EE_DIFFERENTIAL_PKG SQL Statements

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

Line: 40

   Select org_information4 Seta_Classification
   From   hr_organization_information hoi
   Where  hoi.organization_id = p_org_id
   And   hoi.org_information_context = 'ZA_NQF_SETA_INFO';

Line: 67

    select nvl(sum(decode(p_emp_type,'FA',FA,'FC',FC,'FI',FI,'FW',FW,'MA',MA,'MC',MC,'MI',MI,'MW',MW)),0)
    into l_cnt
    from per_za_employment_equity
    where legal_entity_id = p_legal_entity_id
    and report_id = p_report_id
    and employment_type=p_employment_type;

Line: 74

    select nvl(sum(FA)+sum(FC)+sum(FI)+sum(FW),0)
    into l_cnt
    from per_za_employment_equity
    where legal_entity_id = p_legal_entity_id
    and report_id = p_report_id
    and employment_type=p_employment_type;

Line: 81

    select nvl(sum(MA)+sum(MC)+sum(MI)+sum(MW),0)
    into l_cnt
    from per_za_employment_equity
    where legal_entity_id = p_legal_entity_id
    and report_id = p_report_id
    and employment_type=p_employment_type;

Line: 103

    select nvl(SUM(TOTAL),0)
    into l_cnt
    from per_za_employment_equity
    where legal_entity_id = p_legal_entity_id
    and   report_id in ('ED','EDF')
    and employment_type=p_employment_type;

Line: 111

    select nvl(SUM(TOTAL),0)
    into l_cnt
    from per_za_employment_equity
    where legal_entity_id = p_legal_entity_id
    and   report_id in ('EDI','EDFI')
    and employment_type=p_employment_type;