APPS.PER_IN_ASG_LEG_HOOK SQL Statements

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

Line: 57

       SELECT name
       FROM   hr_all_organization_units_tl
       WHERE  organization_id = p_org_id
       AND    language        = userenv('LANG');

Line: 63

        SELECT scl.segment1,scl.segment2,scl.segment4
        FROM   per_all_assignments_f asg
              ,hr_soft_coding_keyflex scl
              ,fnd_sessions ses
        WHERE  asg.assignment_id = p_assignment_id
        AND    asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
        AND    ses.session_id = userenv('SESSIONID')
        AND    ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line: 163

    pay_in_ff_pkg.check_pf_update
         (p_effective_date   => p_effective_date
         ,p_dt_mode          => p_dt_mode
         ,p_assignment_id    => p_assignment_id
	 ,p_gre_org          => l_gre_org
         ,p_pf_org           => l_pf_org
	 ,p_esi_org          => l_esi_org
         ,p_message          => l_message
         ,p_gre              => l_gre_id
	 ,p_pf               => l_pf_id
         ,p_esi              => l_esi_id
         );

Line: 221

PROCEDURE check_asg_update (p_datetrack_update_mode   IN VARCHAR2
                           ,p_effective_date           IN DATE
                           ,p_assignment_id            IN NUMBER
                           ,p_segment1                 IN VARCHAR2 -- tax unit
                           ,p_segment2                 IN VARCHAR2 -- pf_org
                           ,p_segment3                 IN VARCHAR2 -- pt_org
                           ,p_segment4                 IN VARCHAR2 -- esi_org
                           ,p_segment5                 IN VARCHAR2 -- factory
                           ,p_segment6                 IN VARCHAR2 -- estb
                           ,p_segment8                 IN VARCHAR2 -- PGA flag
                           ,p_segment9                 IN VARCHAR2 -- Sub Interest
                           ,p_segment10                IN VARCHAR2 -- Director
                           ,p_segment11                IN VARCHAR2 -- Specified
                           )
IS
l_procedure  VARCHAR2(100);

Line: 239

    l_procedure := g_package ||'check_asg_update';

Line: 244

       (p_dt_mode             => p_datetrack_update_mode
       ,p_effective_date      => p_effective_date
       ,p_assignment_id       => p_assignment_id
       ,p_gre_id              => p_segment1
       ,p_pf_org_id           => p_segment2
       ,p_pt_org_id           => p_segment3
       ,p_esi_org_id          => p_segment4
       ,p_factory_id          => p_segment5
       ,p_estab_id            => p_segment6
       ,p_pga_flag            => p_segment8
       ,p_subint_flag         => p_segment9
       ,p_director            => p_segment10
       ,p_specified           => p_segment11
       );

Line: 269

END check_asg_update;