APPS.JTF_UMUTIL SQL Statements

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

Line: 18

    select usertype_id
    into utype_id
    from jtf_um_usertypes_b
    where usertype_key = utype_key
    and effective_start_date = effective_date;

Line: 42

    select subscription_id
    into subscr_id
    from jtf_um_subscriptions_b
    where subscription_key = subscr_key
    and effective_start_date = effective_date;

Line: 66

    select template_id
    into tmpl_id
    from jtf_um_templates_b
    where template_key = tmpl_key
    and effective_start_date = effective_date;

Line: 90

    select approval_id
    into appr_id
    from jtf_um_approvals_b
    where approval_key = appr_key
    and effective_start_date = effective_date;

Line: 120

    select approval_id
    into appr_id
    from jtf_um_approvals_b
    where approval_key = appr_key
    and effective_start_date = effective_date;

Line: 152

    select subscription_id
    into subscr_id
    from jtf_um_subscriptions_b
    where subscription_key = subscr_key
    and effective_start_date = effective_date;

Line: 177

    select user_id
    into u_id
    from fnd_user
    where user_name = uname;