DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PEOPLE_LOV_V

Line 1667: FROM pa_people_lov_v

1663: if (p_approver_source_id is null and p_approver_source_name is not null) then
1664: begin
1665: SELECT resource_source_id, resource_type_id
1666: INTO l_approver_source_id, l_approver_source_type
1667: FROM pa_people_lov_v
1668: WHERE name = p_approver_source_name;
1669: exception when TOO_MANY_ROWS then
1670: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1671: ,p_msg_name => 'PA_APPR_SOURCE_NAME_MULTIPLE');