APPS.POS_SUPP_APPR SQL Statements

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

Line: 361

  l_insertion_type            VARCHAR2(30);

Line: 452

          SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
            SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
            WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate)
              between person.effective_start_date
              and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
              and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
              and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
              and asg.assignment_status_type_id not in (
                SELECT assignment_status_type_id FROM per_assignment_status_types
                WHERE per_system_status = 'TERM_ASSIGN'
              ) and trunc(sysdate) between asg.effective_start_date
              and asg.effective_end_date order by person.last_name
            ) where rownum = 1;

Line: 474

        SELECT employee_id
        into l_next_approver_id
        FROM fnd_user
        WHERE user_id = g_next_approvers(l_approver_index).orig_system_id
          and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);

Line: 643

        SELECT fu.user_id, fu.user_name, hp.person_first_name, hp.person_last_name
        into user_id, user_name, user_firstname, user_lastname
        FROM fnd_user fu, hz_parties hp
        WHERE fu.user_name = wf_approver
          and fu.person_party_id = hp.party_id(+)
          and rownum = 1;

Line: 1238

  ame_api2.updateApprovalStatus( applicationIdIn=>ameApplicationId,
                                 transactionIdIn=>suppid,
                                 transactionTypeIn=>ameTransactionType,
                                 approverIn => l_current_approver);

Line: 1243

  l_progress := 'Process_Response_Internal: 005 -- Updated AME for transactiontype -'||ameTransactionType||
    ' and transactionId - '||suppid;

Line: 1460

              SELECT person_id, full_name into l_person_id,l_full_name FROM (
                       SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
                       WHERE asg.position_id = l_orig_system_id and trunc(sysdate) between person.effective_start_date
                       and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
                       and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
                       and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
                       and asg.assignment_status_type_id not in (
                          SELECT assignment_status_type_id FROM per_assignment_status_types
                          WHERE per_system_status = 'TERM_ASSIGN'
                       ) and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
                       order by person.last_name
                ) where rownum = 1;

Line: 1487

        SELECT employee_id into l_person_id
             FROM fnd_user
             WHERE user_id = l_orig_system_id
             and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);

Line: 1514

           SELECT position_id, job_id INTO l_position_id, l_job_id
           FROM per_all_assignments_f
           WHERE person_id = l_person_id
                and primary_flag = 'Y' and assignment_type in ('E','C')
                and assignment_status_type_id not in
                  (select assignment_status_type_id
                  from per_assignment_status_types
                  where per_system_status = 'TERM_ASSIGN')
                and TRUNC ( effective_start_date ) <=  TRUNC(SYSDATE)
                AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
                and rownum = 1;

Line: 1527

               SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;

Line: 1531

               SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;

Line: 1554

          marshalField(approverList(i).api_insertion, quoteChar, fieldDelimiter);

Line: 1715

        SELECT hp.person_first_name, hp.person_last_name
        into user_firstname, user_lastname
        FROM fnd_user fu, hz_parties hp
        WHERE fu.user_name = wf_approver
          and fu.person_party_id = hp.party_id(+)
          and rownum = 1;