APPS.PER_US_ADD_LEG_HOOK SQL Statements

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

Line: 14

    select asg.assignment_id
    from   per_assignments_f asg
    where  asg.person_id = p_person_id
    and    asg.assignment_type='E'
    and    asg.payroll_id is not null /*bug 10008870 */
    and    p_effective_date between asg.effective_start_date
                                and asg.effective_end_date;

Line: 49

PROCEDURE UPDATE_US_ADDRESS
         (P_STYLE in varchar2
         ,P_PRIMARY_FLAG in varchar2
         ,p_address_id in number
         ,P_EFFECTIVE_DATE in DATE
         )
AS

l_assignment_id per_assignments_f.assignment_id%TYPE;

Line: 60

    select asg.assignment_id
    from   per_assignments_f asg,
           per_addresses padd
    where  asg.person_id = padd.person_id
    and    padd.address_id = p_address_id
    and    asg.assignment_type='E'
    and    asg.payroll_id is not null /*bug 10008870 */
    and    p_effective_date between padd.date_from
                                and nvl(padd.date_to,hr_api.g_eot)
    and    p_effective_date between asg.effective_start_date
                                and asg.effective_end_date;

Line: 90

END UPDATE_US_ADDRESS;